Top 5 values with corresponding text
 

In cells B2:B32 I have percentages. I have a formula in cells P2:P6 that
gives me the top 5 percentages in column B. I would like a formula in cells
O2:O6 that give me the text in column K that matches the percentage in column
P.

For example, I have 78% in cell P2. I would like O2 to have a formula that
looks for 78% in column B and gives me the corresponding text in column K.

Thanks.

Top 5 values with corresponding text
 

Try this

=VLOOKUP(P2,$B$2:$K$32,10,FALSE)

Mike

"Jambruins" wrote:

In cells B2:B32 I have percentages. I have a formula in cells P2:P6 that
gives me the top 5 percentages in column B. I would like a formula in cells
O2:O6 that give me the text in column K that matches the percentage in column
P.

For example, I have 78% in cell P2. I would like O2 to have a formula that
looks for 78% in column B and gives me the corresponding text in column K.

Thanks.

Top 5 values with corresponding text
 

The only problem with that is that I have three 78% so it is finding the same
text 3 times instead of finding each occurance of the 78%. Any ideas?
Thanks.

"Mike H" wrote:

Try this

=VLOOKUP(P2,$B$2:$K$32,10,FALSE)

Mike

"Jambruins" wrote:

In cells B2:B32 I have percentages. I have a formula in cells P2:P6 that
gives me the top 5 percentages in column B. I would like a formula in cells
O2:O6 that give me the text in column K that matches the percentage in column
P.

For example, I have 78% in cell P2. I would like O2 to have a formula that
looks for 78% in column B and gives me the corresponding text in column K.

Thanks.