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
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Oct 19, 2019

Hi gnaga 

 

Please try below formula:

 

=INDEX(A:A,MATCH(MAX(C:C),C:C))

 

Sample file is also attached for your reference. Hope it will work.

 

Thanks

Tauqeer

 

 

Resources