Lookup a value in a table based on the row and the column fields

[robyrux]

I have a 2-dimensional table and I need to select the value based on the values of the row and the column. A sort of (X,Y) coordinate as input and as output the text that is contained in the X,Y cell.
Example below

	a	b	c	d
1	apple	pear	mango	...
2	tomato	salad	...
3

For the combination (a,2) I need to be able to extract tomato.

The rows and columns cannot be sorted to perform a vlookup.

 

[Fluff]

Maybe

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I
1
2	apple	pear	mango	...			Row	2	tomato
3	tomato	salad	...				Col	1
4
Main

Cell Formulas
Range	Formula
I2	I2	=INDEX(A2:E4,H2,H3)

 

[robyrux]

Thank you, it requires an additional mapping but then it works!

 

[Fluff]

You're welcome & thanks for the feedback.