title: VLOOKUP across several columns in two workbooks
body: <p>I have 2 workbooks.</p>
  
  <p>First is called <code>June2122.xls</code></p>
  
  <p>It has columns such as <code>Last Name</code> (B2:B300), <code>First Name</code> (C2:B300), etc...</p>
  
  <p>Second is <code>June Emails.xls</code></p>
  
  <p>It has columns such as <code>Last Name</code> (B2:B300), <code>First Name</code> (C2:C300), <code>Email Address</code> (D2:D300). These three columns are in a name range called <code>Data_Table</code></p>
  
  <p>What I need to do is compare the <code>First Name</code> and <code>Last Name</code> (B2:C2) from <code>June2122.xls</code> with the <code>First Name</code> and <code>Last Name</code> (B2:C2) from <code>June Emails.xls</code>. If they match then I need to populate the email address from <code>June Emails.xls</code> (D2) into a new cell on <code>June2122.xls</code></p>
  
  <p>All cells are formated as "General".</p>
  
  <p>I've tried several formulas, the closest I've got was this one:</p>
  
  <p><code>=IF(ISNA(VLOOKUP(B2,'June Emails.xls'!Data_Table,2,TRUE)),0,VLOOKUP(C2,'June Emails.xls'!Data_Table,3,TRUE))</code></p>
  
  <p>and all I get is a "FALSE" in the cell the email should be populating in.</p>
  
  <p>Can anyone help with this? Thanks very much in advance!</p>