All,

I am working with a sample spreadsheet that I am hoping can pull together information from a specific area on another table (much like a VLOOKUP or HLOOKUP) except it requires multiple conditions. The following conditions are necessary to create a summary table:
  1. Production Location
  2. Car Model
  3. Type of Car

Hopefully, these conditions will be able to reference the second table to generate the following information based on the given conditions:
  1. Price of Car
  2. Cost to make car


I have the attached spreadsheet below to use as a visual.
Populating Multiple Condition Table.xlsx

Thanks,
Scott.