title: How to do a lookup or index/match in Access?
body: <p>I'm new to access and I'm struggling on how to use lookups since vlookup is not available in Access. I want to get the values that correspond to a certain ID/tagging.  </p>
  
  <p>I have 2 tables. </p>
  
  <p>Table A contains values let's say Product Number, Product Type, Price, Remaining Stock #, Product Type+Product Number Tag. Let's say product number is not unique but combining it with its product type, it will be unique so I created that tag.</p>
  
  <p>Table B contains Seller's Name, # of items Sold, Product Number, Product Type, Product Type+Product Number Tag.</p>
  
  <p>Now using Table A and Table B, how can I create a query/table that will allow me to use that "Product Number + Product Type" Tag when I try to get the price of that certain item so that I can get the total revenue of each seller.  </p>
  
  <p>I hope you understand what I'm trying to say. What I just want to do is I want to use this "Type+Number" Tag as a reference point in getting data of that respective item when I try to create queries/tables. It's just like an INDEX/MATCH in Excel. But how to do it in Access? </p>
  
  <p>Please tell me if it's unclear. </p>
  
  <p>Thank you! </p>