On 1 Jun, 14:21, vezerid wrote:
On Jun 1, 4:09 pm, wrote:

I have two lists of values. Some of list A are in List B and I want a
formula to tell me which ones.

I would like it to return a value of PRESENT, NOT PRESENT for every
value in List A depending on whether it appears in B.

Can anyone help with this?

=IF(COUNTIF(B:B,A2)0,"PRESENT","NOT PRESENT")

HTH
Kostis Vezerides

Many thanks - problem solved.