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.

"Max" wrote:

Did you change the criteria formula in A2 like I mentioned in my response,

Just replace the criteria formula in A2 with:
=IF(B!A2="","",IF(ISNUMBER(MATCH(B!A2,A!A:A,0)),RO W(),""))
then copy down

It should work fine. Try it again.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Adurr" wrote:
OK I downloaded your spreadsheet and it was great, I was able to find
unmatched entries, I changed your formula to find matched entries like so:

=IF(ROW(A1)COUNT($A:$A),INDEX(SonySI!A:A,SMALL($A :$A,ROW(A1))),"")

Everything comes up blank, I have missed something, I just don't know what.