If and vlookup nested formula

Options

I'm looking to create a formula that if a cell matches this criteria, vlookup a different column info for multiple cell matches as a nested formual.

If Product Identifier matches A, search for org name in a different sheet and tell me if it exists there, if product identifier matches B, search for org name in a 3rd different sheet and tell me if it exists there, etc, etc.

Best Answer

  • John_Foster
    John_Foster ✭✭✭✭✭✭
    Answer ✓
    Options

    This is doable. the formula would need to look something like the below, with the relevant details and ranges in the VLOOKUP parentheses.

    =IF([Product Identifier]@row = "A",VLOOKUP(),IF([Product Identifier]@row = "B",VLOOKUP(),""))

    John

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!