Thanks for the help, I got it working.
TedT

"Max" wrote:

Maybe you're trying to do something like this, in say G1:
=INDEX(A:A,MATCH(MAX(F:F),F:F,0))

G1 returns the value in col A corresponding to the max in col F. If there's
ties in the maximum values in col F, it'll return only the the value
corresponding to the 1st maximum (the one higher up)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TedT" wrote:
Hi,
I am not sure how to accomplish this task.

I have multiple columns of data. I am locating a value in a column (F) on
the right using vlookup to find the max value of the data in this column.

Now I wnat to find the corresponding data that is in the cell in column (A)
that is in the same row as the data I found using my vlookup.

I have tried a few ideas, none seem to work - I have a feeling this mis much
easier than I think.
Thanks
TedT