Hi,

I see I am not the first one to ask this question, but I see some formula's
which work, but I would like to know why.

I used: =IF(ISNA(MATCH(A:A;B:B;0));"";INDEX(D:D;MATCH(A:A; B:B;0)))

But why D:D??

Well, what I would like to do is the following:

I have 2 columns with numbers, column A and column B. Say that B is the new
data/new version of the data. Some numbers will be gone (compared to column
A) and some numbers will be new (compared to column A). Is it possible to
make a fomula that shows me which number is new in column B and which number
is gone in column B, compared to column A?!

Thanks a lot in advance.

Marieke