I just want to do a simple function IF formula but it isnt working

Options
Sue08
Sue08
edited 04/07/22 in Formulas and Functions

Hi

I have created the input in these cells via a result of a VLOOKUP formula and now I want to use this cell to create results in another cell via a simple IF formula.

If the cell finds "#NO MATCH" then return No and if not return Yes

Im currently using

and am getting the results in column 2



Hi

Dont worry I can see the bracket missing is the issue

Pls disregard this question for assistance

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!