Need Formula to Match Names in 2 Different Sheets

rmc0030

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

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.