lookup two arguments

[catrrmg]

Hi all! I've got the following table:
A B C D E
1 t1 t1 t1 t2 t2
2 st1 st2 st3 st1 st2
3 v1 v2 v3 v4 v5 and so on...
What I'm trying to do is: find the value that corresponds to the arguments
in row 1 and 2, eg:
looking for
t1 & st2 should return v2. Any ideas? Thanks in advance.

 

[papou]

Hi
With values from A1 to E3
May be try this formula :
=INDEX(A3:E3,MATCH("t1",A1:E1,0),MATCH("st2",A2:E2,0))

HTH
Cordially
Pascal

 

[catrrmg]

cheers mate.
I'll give it a go.

Hi
With values from A1 to E3
May be try this formula :
=INDEX(A3:E3,MATCH("t1",A1:E1,0),MATCH("st2",A2:E2,0))

HTH
Cordially
Pascal

 

[Teethless mama]

A B C D E
1 t1 t2 t1 t2 t2
2 st1 st2 st2 st1 st2
3 v1 v2 v3 v4 v5

=INDEX(A3:E3,MATCH("t1",A1:E1,0),MATCH("st2",A2:E2,0))

the example above, your formula returns incorrect value v2 instead of v3

 

[Teethless mama]

=INDEX(A3:E3,MATCH(1,INDEX((A1:E1="t1")*(A2:E2="st2"),),))