I mean copy the formula down Col C, till the end of your data set...

"George" wrote:



"Sheeloo" wrote:

Assume both sheets in same workbook
Sheet 1 your list (Col A & B)
Sheet 2 e-bay list (Col A & B)

Enter this in C1 of Sheet 2
=VLOOKUP(A1,Sheet2!A:A,1,False)

and copy down.

Now filter on #N/A
these will be the items not in eBay file


I have both the in the same book but when I put in the formula I get an error message saying the formula is wrong.

What do you mean by "copy down" and how far down do I copy it?

Thank you for your help, I will try it again on Monday.