Reverse Vlookup Using Choose Function

[Rick Rothstein]

Country	Capital
India	New Delhi
Great Britain	London
Malaysia	Kuala Lumpur
China	Hong Kong

If you have to reverse vlookup a data table, you can a combination of INDEX and MATCH.

Another way to do this is by using a combination of VLOOKUP and CHOOSE

The following formula can be used for the table above to return the country name corresponding to the capital named that is used as the lookup value.

=VLOOKUP("London",CHOOSE({2,1},A2:A5,B2:B5),2,0). Note how the index of the two ranges are reversed within the CHOOSE function.

I'm a little puzzled as to why you reversed the order of both arguments tot he CHOOSE function... this normally ordered CHOOSE function appears to return the same values as the formula you posted...

=VLOOKUP("London",CHOOSE({1,2},B2:B5,A2:A5),2,0)

Am I missing something here?

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA