R
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
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