Hi All,
Here is the example
COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4
10 56 60 12
20 86 12 8
30 16 80 60
40 5 15 4
Its a 4 column table and i need to look up the highest value in column 4 and return the data of column 3 in a cell. I tried with VLOOKUP but it does not work since the column is not sorted. Is there another way.
Brgds,
Bookmarks