Forum Discussion
Solved
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 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))
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))
