In Excel, how to compare 1 cell with a column of values ​​in two workbooks

Question

I tried to find the answer, but could not - I am a successful novice.

Our company posted a webinar, we got a table of participants, company names, etc.

I have been instructed to compare the list of participants / table with our CRM database of our company to find out if they are in the system. Comparison only by company name.

I created an export from our CRM system of all the companies that we have in the CRM system, as a file with one excel column (column A, company name, 732 rows).

I need to compare the xls column of the CRM export with the Attendee table, the company name (column E2-E180), and mark each one that already exists in the CRM system.

I would like to put the text “NO MATCH” or “MATCH” on the Participant Sheet in column F in the row of the company that was not found.

Can someone give some suggestions / formulas, so I don't need to do this manually one at a time.

Answer 1

=IF(COUNTIF($D$2:$D$5,A2)>0, "Match", "No Match")

Use this, where D2: D5 is the list of existing companies, and A2 is the cell where the company you want to find is located.