Look at all the IDs in Cell A and check if its in Cell B, If in Cell B, Yes and if Not No in Cell C. I tried using the find function but not getting it.
The Vlookup is giving me what it finds in Cell B and putting #NA in other which I don’t like. Any help appreciated. Thanks
Please Ignore my Cell Arrangement of C A B - There are 3 columns below.


C A B
Result ID ID
No 112 145
No 123 168
No 137 179
No 139 185
Yes 145 191
No 158 197
Yes 168
No 177
Yes 191
Yes 197
No 199

Hi

Use COUNTIF():
=IF(COUNTIF($B$2:$B$12,A2)>0,"Yes","No")
Copy the formula right to the bottom of your list.

Thanks Whatsup - Works great! But how do I make the formula give me an empty cell if I copy the formula way below the last cell with ID so that the formula can capture new IDs as they are coming in without showing me No until it sees an ID.

Like saying If No IDs in any Cell B (B5) I get "empty" rather than No. Thanks!!

That way:
=IF(A2="","Empty",IF(COUNTIF($B$2:$B$12,A2)>0,"Yes","No"))
The example sticks to the first description of yours, somehow you got the sample-list mixed up

Thanks Whatsup. Yeah I rearranged the columns cos they were getting messed up but you understand my question and you solved it. Thanks - It works! I appreciate it.