have to find largest of all values and display the corresponding item

item I II III
i 2 j a 1 1 2 3
i 2 j a 2 13 11 6
i 2 j a 3 17 14 5
i 2 j a 4 10 5 12
i 2 j a 5 4 18 9
i 2 j a 6 7 8 19 for1 for2 for3

have to find largest of all values and display the corresponding item
eg
(formula)forI
17 is largest so it should display a3(last 2 letters of the item)
(formula)for2
18 is largest so it should display a5
(formula)for3
19 is largest so it should display a6




Please help me ASAP
Zohar Batterywala
zoharsb at gmail dot com

cross post @
http://www.mrexcel.com/forum/excel-...st-all-values-display-corresponding-item.html
http://www.excelforum.com/excel-for...alues-and-display-the-corresponding-item.html

Not real sure of what you are asking, but if you are looking for the largest value, you can use the LARGE, MAX or RANK formulas. Mix that with an if else statement and it would work.