Hi,

If I have 2 sheets both with a list of unique identifiers on it, what is the
best way to run a query which will check to see if I have all the IDs in one
that are in the other:

i.e.
Sheet 1: (being the master sheet which will always be correct)

A
B
C
D

Sheet 2: ( A data sheet reporting on Sheet 1)

A
B
C

I woul dlike a formula in sheet 2 to return something like, "ID Missing" or
better still: "ID "D" is missing"

thanks!