title: Excel matching separate first and last name columns to another sheet containing a combined "last, first name" column.
body: <p>I have searched and tried various VLOOKUP and MATCH formulas for matching separate first and last name columns to another sheet containing a combined "last, first name" column.  I'm new to excel formulas like this.</p>
  
  <p>Sheet 1
  Column A is Last Name
  Column B is First Name</p>
  
  <p>Sheet 2
  Column G is Last Name, First Name
  Also in Column H there is an additional Last Name, First Name that I'd like to search for matches also if possible.</p>
  
  <p>I'd like to find which names from Sheet 1 match data on Sheet 2.</p>
  
  <p>Thank You!</p>