In a cells of a column the following formula is entered.

IF(ISNA(VLOOKUP(D4;$B$4:$B$200;1;0));"";VLOOKUP(D4;$B$4:$B$200;1;0))

This formula produces all the entries that are in both the B column and the
D column.

What formula would produce only the entries that are in the D column but *
not* in the B column

Reply via email to