SOLVED

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

@spelo100 

=VLOOKUP(A5&C5,CHOOSE({1,2},$I$5:$I$19&$J$5:$J$19,$K$5:$K$19),2,0)

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.

@spelo100 

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

=INDEX($I$5:$K$19,MATCH(A5&C5,$I$5:$I$19&$J$5:$J$19,0),3)

This has to be entered as arrayformula as well.