Excel: Formula with CHOOSE functio in three table same size


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!

ABCDEFGH
1Tabella1ABCDcriteria1Tabella1
21zacxuxtorzorriga2
32macdaxmelrozcolonnaD
43fraannmarrasresultroz
54joeluitinaff
6
7
8Tabella2ABCD
91nonnikchisas
102nulminperfeb
113progiusbachi
124niepocmantet
13
14
15Tabella3ABCD
161arrbraitasfi
172incnercomuna
183besforpermia
194rotcogecasoc

Sheet1



Worksheet Formulas
CellFormula
H4=INDEX(INDIRECT(H1),MATCH(H2,righe,0),MATCH(H3,colonne,0))

Workbook Defined Names
NameRefers To
colonne=Sheet1!$B$1:$E$1
righe=Sheet1!$A$2:$A$5


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of April 25, 2015.


For more resources for Microsoft Excel