title: In Excel, how to compare 1 cell against a column of values in two workbooks
body: <p>Tried to find an answer but could not - I am an excel novice. </p>
  
  <p>Our company put on a webinar, we received excel spreadsheet of attendees, names company names, etc.</p>
  
  <p>I am tasked with comparing the Attendee list/spreadsheet with our company CRM database to see if they are already in the system. Comparing by company name only. </p>
  
  <p>I created an export from our CRM system of all companies we have in the CRM system as a single column excel file (column A, company name, 732 lines). </p>
  
  <p>I need to compare the CRM export xls column A to the Attendee Spreadsheet, Company Name (column E2-E180) and flag each one that already exists in the CRM system. </p>
  
  <p>i would like to put a "NO MATCH" or "MATCH" text on the Attendee Sheet in column F on the row of the company that was not found. </p>
  
  <p>Can anyone give some suggestions/formulas so I do not have to perform this manually one by one. </p>