Forum Discussion
What formula should I use?
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...
=IF(ISNUMBER(MATCH(indeed_applicant, website_list, 0)), "X", "")
or
=IF(COUNTIF(website_list, indeed_applicant), "X", "")