Checking whether a value in a list is present in a second list

  • Thread starter Thread starter wrethams
  • Start date Start date
W

wrethams

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?
 
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?
Click to expand...

I may have found it -

=MATCH(C3,$E$3:$E$210,0)

If so I congratulate myself.
 
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?
Click to expand...

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

HTH
Kostis Vezerides
 
=isnumber(match(a1,b:b,0))
will return True or false if A1 occurs in B.

=if(isnumber(match(a1,b:b,0)),"Present","Not Present")
would return those strings.
 
=isnumber(match(a1,b:b,0))
will return True or false if A1 occurs in B.

=if(isnumber(match(a1,b:b,0)),"Present","Not Present")
would return those strings.
Click to expand...

Many thanks - problem solved.
 
Back
Top