D
Don
I have a spreadsheet that has a vertical list of data that is driven by
dates. The same date will have many entries of different formulas and
weights. The formulas or weights could be the same for multiple days.
A B C
1/26/09 F123 270000
1/26/09 F852 60000
1/26/09 F331 90000
1/27/09 F456 150000
1/27/09 F331 45000
1/27/09 F876 60000
I would like to create a spreadsheet so the user can download the data above
into a worksheet and based on the date selection, a formaula will return the
days value of Pounds, then Formula.
This is what I would like to see:
A B C D
1 1/26/09 1/27/09
2 Pounds Formula Pounds Formula
3 270000 F123 150000 F456
4 60000 F852 45000 F331
5 90000 F331 60000 F876
7
8
I've tried various VLOOKUPs, and now struggling with INDEX MATCH. In each
case, when I place a formula into cell A3, A4, A5 etc, I can pull in the
desired data for the date in question. But when I try the same formula in
C3, C4, C5 to refer to the second date, the LOOKUP still wants to begin at
the begining of the selected range.
The current iteration I'm trying is
=IF(ISNA(INDEX((C2:C100),MATCH(1,($A$1=A2:A100)*(B2=B2:B100),0))),"",(INDEX((C20:C100),MATCH(1,($A$1=A2:A100)*(B2=B2:B100),0))))
Is what I want to do even possible in Excel? Do not want to go to the "dark
side", and use Access.
What am I missing?
dates. The same date will have many entries of different formulas and
weights. The formulas or weights could be the same for multiple days.
A B C
1/26/09 F123 270000
1/26/09 F852 60000
1/26/09 F331 90000
1/27/09 F456 150000
1/27/09 F331 45000
1/27/09 F876 60000
I would like to create a spreadsheet so the user can download the data above
into a worksheet and based on the date selection, a formaula will return the
days value of Pounds, then Formula.
This is what I would like to see:
A B C D
1 1/26/09 1/27/09
2 Pounds Formula Pounds Formula
3 270000 F123 150000 F456
4 60000 F852 45000 F331
5 90000 F331 60000 F876
7
8
I've tried various VLOOKUPs, and now struggling with INDEX MATCH. In each
case, when I place a formula into cell A3, A4, A5 etc, I can pull in the
desired data for the date in question. But when I try the same formula in
C3, C4, C5 to refer to the second date, the LOOKUP still wants to begin at
the begining of the selected range.
The current iteration I'm trying is
=IF(ISNA(INDEX((C2:C100),MATCH(1,($A$1=A2:A100)*(B2=B2:B100),0))),"",(INDEX((C20:C100),MATCH(1,($A$1=A2:A100)*(B2=B2:B100),0))))
Is what I want to do even possible in Excel? Do not want to go to the "dark
side", and use Access.
What am I missing?