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" wrote in message
...
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" wrote in
message
...
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" wrote in message
...
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" wrote in
message
...
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.

.