Functions to look at data in table and put it in cell

New Contributor

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.
2021-04-07 12_27_33-Book2 - Excel.png

3 Replies
best response confirmed by Neimis (New Contributor)



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):






Thank you !
Your table is easier to understand. It's clean and don't use much space.
You are welcome.