Index and Match-wrong value

Hello from Steved

=INDEX(Sheet1!$B$1:$B$2000,SMALL(IF(Sheet1!
$C$1:$D$2000<>"",ROW(Sheet1!$C$1:$D$2000)),ROW()))

Ok The above picks up the value in Column B from Sheet1
and puts it in Column A sheet2.

I'm getting the wrong value which suguest to me that
I need a Index and Match Formula.

Sheet1 Column C and Column D the same data
Sheet2 Column B and Column C the same data

Ok Please what formula would give a value in Sheet2
after looking in Sheet1 Column C and Column D then
looking Sheet2 Column B and Column C and putting the value
from Sheet1 Column B to Column A in Sheet2

Thankyou.

Try this in A1 of Sheet2:

=SUMPRODUCT((B1=Sheet1!$C$1:$C$20)*(C1=Sheet1!$D$1:$D$20)*Sheet1!$B$1:$B$20)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Steved" <[email protected]> wrote in message
news:[email protected]...
> Hello from Steved
>
> =INDEX(Sheet1!$B$1:$B$2000,SMALL(IF(Sheet1!
> $C$1:$D$2000<>"",ROW(Sheet1!$C$1:$D$2000)),ROW()))
>
> Ok The above picks up the value in Column B from Sheet1
> and puts it in Column A sheet2.
>
> I'm getting the wrong value which suguest to me that
> I need a Index and Match Formula.
>
> Sheet1 Column C and Column D the same data
> Sheet2 Column B and Column C the same data
>
> Ok Please what formula would give a value in Sheet2
> after looking in Sheet1 Column C and Column D then
> looking Sheet2 Column B and Column C and putting the value
> from Sheet1 Column B to Column A in Sheet2
>
> Thankyou.

Thankyou very much.

Just What I was requiring.

>-----Original Message-----
>Try this in A1 of Sheet2:
>
>=SUMPRODUCT((B1=Sheet1!$C$1:$C$20)*(C1=Sheet1!$D$1:$D$20)
*Sheet1!$B$1:$B$20)
>--
>HTH,
>
>RD
>
>----------------------------------------------------------
-----------------
>Please keep all correspondence within the NewsGroup, so
all may benefit !
>----------------------------------------------------------
-----------------
>
>"Steved" <[email protected]> wrote in
message
>news:[email protected]...
>> Hello from Steved
>>
>> =INDEX(Sheet1!$B$1:$B$2000,SMALL(IF(Sheet1!
>> $C$1:$D$2000<>"",ROW(Sheet1!$C$1:$D$2000)),ROW()))
>>
>> Ok The above picks up the value in Column B from Sheet1
>> and puts it in Column A sheet2.
>>
>> I'm getting the wrong value which suguest to me that
>> I need a Index and Match Formula.
>>
>> Sheet1 Column C and Column D the same data
>> Sheet2 Column B and Column C the same data
>>
>> Ok Please what formula would give a value in Sheet2
>> after looking in Sheet1 Column C and Column D then
>> looking Sheet2 Column B and Column C and putting the
value
>> from Sheet1 Column B to Column A in Sheet2
>>
>> Thankyou.
>
>.
>

You're welcome!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Steved" <[email protected]> wrote in message
news:[email protected]...
> Thankyou very much.
>
> Just What I was requiring.
>
> >-----Original Message-----
> >Try this in A1 of Sheet2:
> >
> >=SUMPRODUCT((B1=Sheet1!$C$1:$C$20)*(C1=Sheet1!$D$1:$D$20)
> *Sheet1!$B$1:$B$20)
> >--
> >HTH,
> >
> >RD
> >
> >----------------------------------------------------------
> -----------------
> >Please keep all correspondence within the NewsGroup, so
> all may benefit !
> >----------------------------------------------------------
> -----------------
> >
> >"Steved" <[email protected]> wrote in
> message
> >news:[email protected]...
> >> Hello from Steved
> >>
> >> =INDEX(Sheet1!$B$1:$B$2000,SMALL(IF(Sheet1!
> >> $C$1:$D$2000<>"",ROW(Sheet1!$C$1:$D$2000)),ROW()))
> >>
> >> Ok The above picks up the value in Column B from Sheet1
> >> and puts it in Column A sheet2.
> >>
> >> I'm getting the wrong value which suguest to me that
> >> I need a Index and Match Formula.
> >>
> >> Sheet1 Column C and Column D the same data
> >> Sheet2 Column B and Column C the same data
> >>
> >> Ok Please what formula would give a value in Sheet2
> >> after looking in Sheet1 Column C and Column D then
> >> looking Sheet2 Column B and Column C and putting the
> value
> >> from Sheet1 Column B to Column A in Sheet2
> >>
> >> Thankyou.
> >
> >.
> >