title: How can I join data from 2 different excel sheets based on one common row?
body: <p>I have an excel spreadsheet with 2 separate sheets within. The first sheet has customer details (Customer_ID | Surname | First Name | Address | Phone Number | etc).</p>
  
  <p>The second sheet contains sale item data (item_id | Description | Price | Customer_id)</p>
  
  <p>Currently in the second sheet, the customer_id column is blank. What I would like to be able to do is enter the customer_id in a row alongside item details, and then have the adjacent cells in that same row populated with the customer data from the first sheet. This combined data would then be used to create a receipt.</p>
  
  <p>Each customer has a unique customer_id, though some of them have the same names (there are multiple John Smiths)</p>
  
  <p>I have played around with VLOOKUP but haven't been able to achieve the desired result. I'm not very good at this. Still learning.</p>
  
  <p>I understand how this would done in SQL, by joining the two sheets (or tables) on the customer_id column, but am not sure how this translates to excel.</p>
  
  <p>Many thanks for your help.</p>