Formula with CHOOSE functio in three table same size

[GerryZ]

hello Everbody
in H2 I made a formula with INDIRECT that gives me back the right result choosing in different tables with the same size.
But now I'm stuck because I'd like to make a similar formula with CHOOSE function
I know is possible but I'm really stuck
Thank you for yor Help!

Book1
	A	B	C	D	E	F	G	H
1	Tabella1	A	B	C	D		criteria1	Tabella1
2	1	zac	fux	tor	zor		riga	2
3	2	mac	dax	mel	roz		colonna	D
4	3	fra	ann	mar	ras		result	roz
5	4	joe	lui	tin	aff
6
7
8	Tabella2	A	B	C	D
9	1	non	nik	chi	sas
10	2	nul	min	per	feb
11	3	pro	giu	sba	chi
12	4	nie	poc	man	tet
13
14
15	Tabella3	A	B	C	D
16	1	arr	bra	ita	sfi
17	2	inc	ner	com	una
18	3	bes	for	per	mia
19	4	rot	cog	eca	soc
Sheet1

Cell Formulas
Range	Formula
H4	=INDEX(INDIRECT(H1),MATCH(H2,righe,0),MATCH(H3,colonne,0))

Named Ranges
Name	Refers To	Cells
colonne	=Sheet1!$B$1:$E$1
righe	=Sheet1!$A$2:$A$5

 

[GerryZ]

Did you type the letter in cell H3 in lower case by any chance? As written, the code is expecting the letter to be upper case... if you need to accept lower case letters, then the formula would need to be this...

=INDEX(A:E,MATCH(H1,A:A,0)+H2,CODE(UPPER(H3))-63)

Yeeesss!!! Works
I don't know what you did but it works
very Short and Clever Formula
Thank you!