Forum Discussion

gnaga's avatar
gnaga
Copper Contributor
Oct 19, 2019

Reverse VLOOKUP

Hi, I would like to find a data which is in the left side column of the lookup data. EXAMPLE Col A        Col B         Col C XYZ          123            12.3% ABC          345            15.2% ...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Oct 19, 2019

gnaga

 

Hi,

 

For now, the known formula for this case is INDEX & MATCH combination as follows:

=INDEX($A$1:$A$3,MATCH(MAX($C$1:$C$3),$C$1:$C$3,0))

 

But soon there will be a new function in Excel called https://support.office.com/en-us/article/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 which will be better and more convenient for this situation.

 

Regards

Resources