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

Never did like VLOOKUP's.....
--
Kathy


"Kathy" wrote:

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