Help with row and colum lookups

[maximillianrg]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Apple
[/TD]
[TD="align: center"]Fig
[/TD]
[TD="align: center"]Peach
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]Fish
[/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"]2
[/TD]
[TD="align: center"]3
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: center"]Mole
[/TD]
[TD="align: center"]4
[/TD]
[TD="align: center"]5
[/TD]
[TD="align: center"]6
[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: center"]RAT
[/TD]
[TD="align: center"]7
[/TD]
[TD="align: center"]8
[/TD]
[TD="align: center"]9
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

Hello Excel Wizards

In the above example, I'm looking for a formula in cell A5 that would contain one fruit and one animal and return the intersecting value. For example the formula would look up the value Fig and Rat and the result would be 8. If the formula contained the words Apple and Fish the result would be 1.

 

[Oeldere]

Book1
	A	B	C	D	E	F	G	H
1		Apple	Fig	Peach		RAT	Fig	8
2	Fish	1	2	3
3	Mole	4	5	6
4	RAT	7	8	9
Blad1

Cell Formulas
Range	Formula
H1	=INDEX($A$1:$D$4,MATCH(F1,$A$1:$A$4,0),MATCH(G1,$A$1:$D$1,0))

 

[maximillianrg]

Hello Oeldere

Thank you so much - that worked - I just had to modify the formula a but as I wanted the lookup values in the formula =INDEX($A$1:$D$4,MATCH("Mole",$A$1:$A$4,0),MATCH("Fig",$A$1:$D$1,0))