Forum Discussion
Functions to look at data in table and put it in cell
Operating System: Windows 10 Version 20H2, 64-bit operating system
Excel Product: Microsoft Office Professional Plus 2016
Hello. I'm new to Excel and don't know how to use function well.
Here. I need to put Code in column E by look at data table on right side.
I would suggest re-structuring the lookup table to look like this (I used a structured table, but you could change it back to a regular range if you wish (table tools/convert to range):
Then, enter this in E2 and hit Ctrl+Shift+Enter (instead of just enter):
=INDEX(Table1[Code],MATCH(1,(Table1[Type]=C2)*(Table1[Color]=D2),0))
3 Replies
I would suggest re-structuring the lookup table to look like this (I used a structured table, but you could change it back to a regular range if you wish (table tools/convert to range):
Then, enter this in E2 and hit Ctrl+Shift+Enter (instead of just enter):
=INDEX(Table1[Code],MATCH(1,(Table1[Type]=C2)*(Table1[Color]=D2),0))
