lookup 2 values in different sheets

[rixanna]

I used this formula in an Excel worksheet to find the data that
correspond to those 2 values.

I used this code for the time being :
Code:

=INDEX(C1:C10,MATCH(1,(A1:A10=Lookup_1)*(B1:B10=Lookup_2),0))



But, what if I want to look in other worksheet?

What I meant here is that I have 2 worksheets, one for table of input
and one for the output. I put the table of data in input_sheet and I
want to have the answer in output_sheet(I assigned all the formula in
output_sheet).

Any suggestion?
Any help is appreciated.

Thank you in advanced

Rgds,
Rixanna

 

[Max]

But, what if I want to look in other worksheet?

=INDEX(C1:C10,MATCH(1,(A1:A10=Lookup_1)*(B1:B10=Lookup_2),0))

Probably something like this (array-entered):
=INDEX('Sheet2'!C1:C10,MATCH(1,('Sheet2'!A1:A10=Lookup_1)*('Sheet2'!B1:B10=Lookup_2),0))
assuming the lookup is on data in Sheet2

---