INDEX MATCH MATCH or something else?

[maywal]

Hello

I have a table with the following:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]1991[/TD]
[TD]1992[/TD]
[TD]1993[/TD]
[TD]1994[/TD]
[/TR]
[TR]
[TD]Industry A[/TD]
[TD]Place A[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Industry B[/TD]
[TD]Place A[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Industry C[/TD]
[TD]Place A[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Industry A[/TD]
[TD]Place B[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Industry B[/TD]
[TD]Place B[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
[TR]
[TD]Industry C[/TD]
[TD]Place B[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[TD]x[/TD]
[/TR]
</tbody>[/TABLE]

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")