Need Formula to Match Names in 2 Different Sheets

I have a list of people in one sheet and I need to know if the names in another sheet are included on the main sheet. What's the easiest way to go about this?


The tricky part is on the source sheet I have a column for first and last name, and the supplemental sheet that I need to check against has separate columns for first and last name

Tags:

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭

    Hi @rmc0030


    You can create a column in both sheets which combines the first and last name. Let's call this Full Name and you can formulate it to get the full name in one column =[First Name column]@row + " " + [Last Name column]@row


    You can then create a checkbox column with the formula =IF(HAS({Reference of column in another sheet which contains the full name}, [Full Name column in current sheet]@row), 1, 0). This formula will check the box in cases where the name is found and leave it blank when not.

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!