Forum Discussion
Solved
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...
=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.
=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.