If Statement with nested VLOOKUP formula

Thu Nghiem
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

  • GrahamWelsby
    GrahamWelsby ✭✭
    Answer ✓

    Hi Thu,

    The column count, is this correct and looking in the correct column numbers.

    You've typed false for the false statement, try putting that in double quotes - "False"

    Thanks Graham

  • GrahamWelsby
    GrahamWelsby ✭✭
    Answer ✓

    Hi @Thu Nghiem, daft question, but I'd need to ask, the range you've set up, I assume does include the columns you need, and are there some "Y"s in the column your looking for?

    Do you have multiple references of the same customer?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!