Forum Discussion
Solved
Help with double cell lookup formula
I am trying to pull a value based on one worksheet data into another, essentially being a vlookup based on ID but also with the condition it matches an item name. Example: I want to find the ...
=VLOOKUP($B3&$A3,CHOOSE({1,2},$F$3:$F$10&$G$3:$G$10,H$3:H$10),2,FALSE)
The CHOOSE function allows to create a lookup range (red) and a return range (purple).
In the attached file i've added the alternative INDEX and MATCH formula.
Thank you OliverScheurich! What exactly is the Choose formula doing, just for my better understanding?
=VLOOKUP($B3&$A3,CHOOSE({1,2},$F$3:$F$10&$G$3:$G$10,H$3:H$10),2,FALSE)
The CHOOSE function allows to create a lookup range (red) and a return range (purple).
In the attached file i've added the alternative INDEX and MATCH formula.