Need vlook up for the largest NO,

[Techtrend]

Neeed vlook up for the largest NO,
Details are mentioned in the attached document

 

[Hui]

A2: =INDEX($K$2:$K$100,MATCH(B2,$L$2:$L$100,0))
Copy down

 

[Ramesh]

I shall perform the following steps:

In column B, I shall use the formula to get the top 5 values:

Write the formula given below in cell B2 and then copy the same for the remaining cells:

=LARGE($L$2:$L$7,ROW(A2)-1)

Then, write a Index match function, in cell A2 as given below and copy the same for remaining cells:

=INDEX($K$2:$K$7,MATCH(B2,$L$2:$L$7,0))

 

[Techtrend]

Thanks for the help

Narendra