Forum Discussion
Using IF statements to determine if any data in a large pool is present in a small pool
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.
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. 🙂
