Contact Lookup/Reference from Another Sheet


I am trying to work out a formula that will raise a flag if any contacts in a column (Attendees) are listed on a separate sheet (VIP).

The attendees column could have multiple names listed, the VIP column will only have one name per row.

I am running into errors with the formulas that I have been trying, and not sure if I am even using the correct formulas. Have tried FIND, MATCH and they do not seem to do it.

Any ideas would be much appreciated.



Best Answer


  • Thank you. That did work a little better than the way I figured it out. I figured out to use If(Contains( but the the has seems like a better fit.

    Thank you again,


  • Genevieve P.
    Genevieve P. Employee Admin

    Ah yes! Contains works as well.

    It's a small difference, but HAS is a function built specifically to search within Multi-Select columns (or multi-select contact lists).

    Glad you got it working!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!