|
Index and Match
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. . |
| All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com