|
[Quoted Text] > 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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rixanna" <fildzana[ at ]gmail.com> wrote in message
news:1155891477.711133.264150[ at ]p79g2000cwp.googlegroups.com...
>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
>
|