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.
Help Article Resources
Check out the Formula Handbook template!