I'm not sure what's happening there. I suppose you did copy A2 down <g. It
should work ok.

Here's a quick working sample,
with the sheets renamed to suit your actuals:
http://cjoint.com/?gApXb22mgF
Compare_B_vs_A_n_filter_matched lines_in_C.xls

Take a look at the sample ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Adurr" wrote:
Yes, I believe that I did, this is the formula that I am using

=IF(SonySI!A2="","",IF(ISNUMBER(MATCH(SonySI!A2,So nyReseller!A:A,0)),ROW(),""))

I either get a blank response now or I get the number the row, but not the
content of the row.