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