Forum Discussion
gnaga
Oct 19, 2019Copper Contributor
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% ...
tauqeeracma
Oct 19, 2019Iron Contributor
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