Assuming your data is in Cols. A & B, in Col C enter this in row 1 and
copy down as far as needed. Adjust the range to meet your needs:

=IF(ISERROR(MATCH(A1,$B$1:$B$1000,0)),"","MATCH FOUND IN ROW
"&MATCH(A1,$B$1:$B$1000,0))

Column C will be blank until a match for that row in A is found in B.
Then the Row number that matches will be returned in the format "MATCH
FOUND IN ROW nn". Of course, if duplicate matches exist, only the
first one found will be returned.

NOTE: if your data range does not begin in row 1, adjust your formula
to account for this by adding row number minus one to the formula.
e.g. if your data starts in row 10, add 9 as such:
=IF(ISERROR(MATCH(A10,$B$10:$B$1000,0)),"","MATCH FOUND IN ROW
"&MATCH(A10,$B$10:$B$1000,0)+9)

Does this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=485637