Excel value and the relevant text column

[Guest]

Hi

Pls assist, if possible on the following:

I have a table with one colum text and another with value. I require an
output with the value and it's description. Eg:
Col A Col B
R01 pear 3.20
R02 orange 8.00
R03 apple 1.00

formax amt in Col B, I used =max(full!B01:B03). How do I also get the
relavant 'orange' text to be included in the cell.
Using Excel 2003 XP
Thanks.

 

[Roger Govier]

Hi

Try
=MAX(B1:B3)&" "&INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3))