You have to adapt it and offset the rows from row 1 compared to where the
data start, if you don't offset it you need to let the index part start in
the first row, i.e.

=INDEX($A$1:$A$50000,MAX((B$14:$F$50000=B4)*(ROW(B $14:$F$50000))))

and enter with ctrl + shift & enter


--

Regards,

Peo Sjoblom


"MrSales" wrote in
message ...

The formula you suggested is returning me an answer from column A but 12
lines below the answer from the same line that I originally wanted.
Maybe I did not convey exactly what I need properly. I want the
information in column A when I find the match in column A,B,C,D,E or
F.

Thanks for the help...


--
MrSales
------------------------------------------------------------------------
MrSales's Profile:
http://www.excelforum.com/member.php...o&userid=32572
View this thread: http://www.excelforum.com/showthread...hreadid=525492