New to VLOOKUP function

[Kathy]

I am new to the VLOOKUP function and I am told that it can do this.

I need to compare two columns of data and find what is new in one of the
columns.

The data is in two separate workbooks, although I could put them in one
workbook if it will facilitate the formula.

So for instance, in workbook (WB) 1, I have a column for customer number
with a bunch of data and in WB2, I have a column for customer number with a
bunch of data. I just want to compare the two customer number columns to each
other and find any new customer numbers added in WB2 that are not in WB1 for
instance.

I tried and couldn't get the formula to work.

Thanks,

 

[Kathy]

Never mind, I figured it out after playing with it awhile longer.

Never did like VLOOKUP's.....

 

[T. Valko]

Try something like this:

In WB2 assume customer numbers are in the range Sheet1 A1:A10.
In WB1 assume customer numbers are in the range Sheet1 A1:A10.

In WB2 Sheet1 enter this formula in B1. A result of "X" means the customer
number *is not* in WB1.

=IF(COUNT(MATCH(A1,[WB1.xls]Sheet1!$A$1:$A$10,0)),"","X")