I've used MATCH and INDEX for this type of thing in the past. Unfortunately,
Excel is tied up on this machine right now, so can't give any more details.
--
HTH,
Barb Reinhardt



"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