INDEX MATCH MATCH or something else?

[maywal]

Hello

I have a table with the following:

		1991	1992	1993	1994
Industry A	Place A	x	x	x	x
Industry B	Place A	x	x	x	x
Industry C	Place A	x	x	x	x
Industry A	Place B	x	x	x	x
Industry B	Place B	x	x	x	x
Industry C	Place B	x	x	x	x

<tbody>
</tbody>

In another sheet I need to pull for instance the value from industry B place B in 1994. I have around 10 different places and industries. I have tried to use an INDEX MATCH MATCH however it is not returning the values correctly.

Example:
=INDEX(RawData!$A$1:$AX$241,MATCH('Baseline by sector'!$C7,RawData!$B$2:$B$241,0),MATCH('Baseline by sector'!$G3,RawData!$E$1:$AX$1,0))

Is there another way of doing this simply? perhaps some kind of HLOOKUP VLOOKUP combo?

any help would be much appreciated.

Thanks

 

[Aladin Akyurek]

Let A:F house the sample.

G1 = Industry B; H1 = Place B; I1 = 1994

In J1 control+shift+enter, not just enter:

=IFERROR(INDEX($C$2:$F$8,MATCH(H1,IF($A$2:$A$8=G1,$B$2:$B$8),0),MATCH(I1,$C$1:$F$1,0)),"not found")