Reverse VLOOKUP

[gnaga]

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%

EFG          105             10.3%

I would like to pick up the data in col A for the maximum value of Col C. 

Here in this example it is "ABC" as 15.2% is the maximum value.

Col C value keeps changing on every update.

TIA

GNAGA

[#2]

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

[#3]

@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 XLOOKUP which will be better and more convenient for this situation.

Regards

[#4]

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)