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
Twifoo's avatar
Twifoo
Silver Contributor
Oct 19, 2019
Another alternative is the powerful combination of LOOKUP-FREQUENCY, like this:
=LOOKUP(2,1/(
FREQUENCY(0,1/(1+C$1:C$3))),
A$1:A$3)

Resources