Forum Discussion
Solved
Using IF statements to determine if any data in a large pool is present in a small pool
Alright, so basically I have a big list of names each with their own unique number in the cell to the right. There are instances where the same name appears several times each with its own unique num...
Based on the screenshot, please try this...
In I2
=IF(ISNA(MATCH(G2,F:F,0)),"NO",H2)
and copy it down.
If that doesn't work as desired, please upload a sample file along with your desired output mocked up manually in a column for few rows to illustrate what you are trying to achieve.
Subodh_Tiwari_sktneer This worked perfectly, thank you very much!
You're welcometfdavid! Glad it worked as desired.
Since the solution offered worked for you as desired, please take a minute to accept the solution as an Accepted Answer and hit the Like button. 🙂