If Statement with nested VLOOKUP formula

Thu Nghiem
edited 12/14/21 in Formulas and Functions

Hi! I would like to return a value from another SmartSheet if one column in that same SmartSheet has a "Y". I have the current formula below, but it's returning a #NO MATCH error... any thoughts?

In summary: return value in column A of SmartSheet Y to SmartSheet X if coulumb B in SmartSheet Y = Yes.

=IF(VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 5, false) = "Y", VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 2, false), false)

Thank you!



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!