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
Answers
-
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 GP| Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!