title: Find a Match between Two Columns by Referring to a List and put the result in a new column
body: <p>I have two columns (column P and column Q) which has a list of companies.</p>
  
  <p>Within that list of companies in column P and Q, there were companies which are called 'global companies'. </p>
  
  <p>I also have a list of that 'global companies' which I got it via email (not in excel format). In that email, there are about 85 companies listed.</p>
  
  <p>The company name in the 'global companies' list and also in column P and column Q were not consistent. For example, there are company written as "Jane <strong>and</strong> Frank" and the same company written as "Jane <strong>&amp;</strong> Frank". Another example is "H Tech Japan" and there is also "H Tech UK", but it is the same company.</p>
  
  <p>How to make excel can identify between column P and column Q which one is a 'global company' (by referring to where I put the 'global companies' list; perhaps in a column of the same sheet or somewhere else)  and put the result of that 'global company' in column R (a new column beside column Q)?</p>