Forum Discussion
Vlookup using two separate columns
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.
=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.
3 Replies
=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.
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.
