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