Matching values between linear sheet and 2 dimensional sheet

[booms]

I’m finding this very hard to get working the way I’d like to, I’ve been trying to use a combination of ADDRESS, SUBSTITUTE, MATCH and it’s all getting a bit unwieldy.


I have two data sources that I want to compare to make sure the values are the same.
One has all numerical values in a single column with a set conditions in the preceding columns. Nice and straight forward and easy to use a SUMIFS on.
The other data source has the values in a two dimensional table, with one set of conditions on the X-axis and other other on the Y-axis.
How can I pull in the values from the 2nd sheet to the first so I can check them off against each other?
e.g.

Sheet 1
Car Model	Car Type	Price
VW	Hatchback	13413
VW	Midsize	13534
VW	Luxury	24564
VW	MPV	23453
Audi	Hatchback	67457
Audi	Midsize	42344
Audi	Luxury	24356
Audi	MPV	24564

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

Sheet2
	VW	Audi
Hatchback	13413	67457
Midsize	13534	42344
Luxury	24564	24356
MPV	23453	24564

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Gerald Higgins]

Here's one way.

Let's assume all your data starts in cell A1 on the relevant sheet.
So sheet 1, cell A1 contains "Car Model".
Sheet 2, cell A1 is blank, and A2 contains "Hatchback".

=OFFSET(Sheet2!$A$1,MATCH(Sheet1!B2,Sheet2!A$2:A$5,0),MATCH(Sheet1!A2,Sheet2!B$1:C$1,0),1,1)

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1	Car Model	Car Type	Price
2	VW	Hatchback	13413	13413
3	VW	Midsize	13534	13534
4	VW	Luxury	24564	24564
5	VW	MPV	23453	23453
6	Audi	Hatchback	67457	67457
7	Audi	Midsize	42344	42344
8	Audi	Luxury	24356	24356
9	Audi	MPV	24564	24564
Sheet1

Cell Formulas
Range	Formula
D2	=INDEX(sheet2!$B$2:$C$5,MATCH(B2,sheet2!$A$2:$A$5,0),MATCH(A2,sheet2!$B$1:$C$1,0))

 

[booms]

How about

Excel 2013/2016

	A	B	C	D
1	Car Model	Car Type	Price
2	VW	Hatchback	13413	13413
3	VW	Midsize	13534	13534
4	VW	Luxury	24564	24564
5	VW	MPV	23453	23453
6	Audi	Hatchback	67457	67457
7	Audi	Midsize	42344	42344
8	Audi	Luxury	24356	24356
9	Audi	MPV	24564	24564

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =INDEX(sheet2!$B$2:$C$5,MATCH(B2,sheet2!$A$2:$A$5,0),MATCH(A2,sheet2!$B$1:$C$1,0)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thanks very much to both of you - using MATCH in 2D was exactly what I needed.

 

[Fluff]

You're welcome & thanks for the feedback