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.