Which formula to use?


Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    =VLOOKUP( [Facility Name]@row, lookup_table, 2, false)

    You'll need to click on the cross-sheet reference when you get to the lookup table part and select both columns in your lookup sheet.

    Let me know if you have any questions.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!