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:
- Production Location
- Car Model
- Type of Car
Hopefully, these conditions will be able to reference the second table to generate the following information based on the given conditions:
- Price of Car
- Cost to make car
I have the attached spreadsheet below to use as a visual.
Populating Multiple Condition Table.xlsx
Thanks,
Scott.
Bookmarks