J
Jambruins
In cells B2:B32 I have percentages. I have a formula in cells P26 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. My top 3 percentages are the same though so I need a formula to lookup
all three cases so I can't just use vlookup.
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.
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. My top 3 percentages are the same though so I need a formula to lookup
all three cases so I can't just use vlookup.
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.