# Reverse VLOOKUP

Highlighted
Occasional Visitor

# 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%

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

3 Replies
Highlighted

# Re: Reverse VLOOKUP

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

Highlighted

# Re: Reverse VLOOKUP

@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

Highlighted

# Re: Reverse VLOOKUP

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)