lookup two arguments

C

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.
 
P

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
 
C

catrrmg

cheers mate.
I'll give it a go.

papou said:
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
 
T

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top