Proper Syntax for IF and VLOOKUP


I am trying to create a formula that will run VLOOKUP if a cell is blank

This doesn't error but it leaves the formula field blank

=IF((USERR3 <> ""), (IF((VLOOKUP(SDR3, {SFDCUsers Range 1}, 2, false)) = 0, "No", "")))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!