Index and Match or VLookup or both


I am trying to recreate this excel formula in smartsheet:

=IF(ISNA(VLOOKUP(B2,'Participating Hotels'!$B:$B,2,FALSE)),"Not Available","Available")

  • "B2" is the Property ID column on my sheet where the results will sit. So it will be ID@row
  • Participating Hotels $B:$B is the base sheet column where all of the data sits. So this would be ID:ID, of course linked to the other sheet.
  • Instead of 2, it would need to be 1 because the ID column in Smartsheet is column 1.

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!