LookUp Text by two criterias

Hello everyone,

I am looking for a formula that will return a text by checking a table that is made of two criterias for example:

Table 1:

	Number1	Number2	Number3	Number4
Date1	Text1	Text2	Text3	Text4
Date2	Text5	Text6	Text7	Text8
Date3	Text9	Text10	Text11	Text12

and i have another table that provides the following

Number2

Date3

?

The "?" should be "Text10"

Can you please help?

Thanks

Assuming your table is A1:E4, and the match criteria is G1 and G2, then this would go in G3:
=INDEX(A1:E4,MATCH(G2,A1:E4,0),MATCH(G1,A1:E4,0))

In E6:
=INDEX(Sheet1!$A$1:$BB$112,MATCH(Sheet2!D6,Sheet1!$A$1:$A$112,0),MATCH(Sheet2!$E$2,Sheet1!$A$1:$BB$1,0))

In F6 you need to change Sheet2!D6 to Sheet2!G6. Then you can copy and paste those two cells all over.

Hello soberguy,

I tried doing that but it still doesn`t work.

Do i need to do something special for this formula to work?

Thanks

Change the format of your cell where you enter it from text to general.

Also, there's no need for a PM. No, I do not Skype.

It is working now.

Thank you very much. Added Rep