gnaga
Well-known Member
- Joined
- Jul 9, 2002
- Messages
- 748
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
Hi,
I have data in two worksheet as follows
Sheet1
A B
1 02-Aug-02 =Want Formula in this
2 03-Aug-02 =Want Formula in this
Sheet2
A B C
1 02-Aug-02 10 10
2 02-Aug-02 10 10
3 02-Aug-02 10 10
4 03-Aug-02 20 20
5 03-Aug-02 20 20
6 03-Aug-02 20 20
In column B of sheet1 I want the formula like =Sheet2!SUMPRODUCT(B1:B3,C1:C3)
but this range should be selected automatically by looking the column A in both sheets.
For Ex A1 in sheet1 is 02-Aug-02 so the formula should select range from sheet2 whose Column A value is matching with the sheet1 A1.
I hope you guys understand my question.
Thanks for help
GNaga
This message was edited by gnaga on 2002-09-03 08:21
I have data in two worksheet as follows
Sheet1
A B
1 02-Aug-02 =Want Formula in this
2 03-Aug-02 =Want Formula in this
Sheet2
A B C
1 02-Aug-02 10 10
2 02-Aug-02 10 10
3 02-Aug-02 10 10
4 03-Aug-02 20 20
5 03-Aug-02 20 20
6 03-Aug-02 20 20
In column B of sheet1 I want the formula like =Sheet2!SUMPRODUCT(B1:B3,C1:C3)
but this range should be selected automatically by looking the column A in both sheets.
For Ex A1 in sheet1 is 02-Aug-02 so the formula should select range from sheet2 whose Column A value is matching with the sheet1 A1.
I hope you guys understand my question.
Thanks for help
GNaga
This message was edited by gnaga on 2002-09-03 08:21