Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

What formula should I use?

Copper Contributor

Hello!

 

I work in HR and was trying to see if I could find a formula that will do what I’m looking for. 

In one tab of my spreadsheet, I type in all the names of applicants that apply through Indeed. In another tab, I type in all the names of applicants that apply through our website. I want to add a column to the Indeed list next to the names that will put an X if their name appears in the list of applicants from our website and leave it blank if they are not in the list. 

It seems like it would be a simple formula but I’m not sure where to start.

 

Thanks!

1 Reply

@kjbourk77 

 

=IF(ISNUMBER(MATCH(indeed_applicant, website_list, 0)), "X", "")

 

or

 

=IF(COUNTIF(website_list, indeed_applicant), "X", "")