You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"TedT" wrote in message
...
Worked fine,
Thank you

"T. Valko" wrote:

Try this:

=INDEX(A:A,MATCH(MAX(F:F),F:F,0))


--
Biff
Microsoft Excel MVP


"Barb Reinhardt" wrote in
message
...
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