Vlookup using two separate columns

New Contributor

Hello.  I need help with creating a formula to look at the input in two separate columns then return a value from a simple table.  I've tried different ways based on my internet searches but they all involve using Index or Match or both, which I'm not opposed to, but I don't know how to use those features.  I've attached an example.  Thank you for your help.  

3 Replies
best response confirmed by allyreckerman (Microsoft)



Enter above formula as arrayformula with ctrl+shift+enter in D4 and copy down.

Awesome! Thank you so much. That works perfectly. Haven't seen anything with the Choose function.


Glad it helped. With INDEX and MATCH it's:


This has to be entered as arrayformula as well.