C
Chad
I have a spreadsheet that contains data that has three identifiers: Week,
Type & Coupon. I was wondering if there was a way to reference this data by
calling out these three identifiers.
Example:
200701 200701 200702 200702 200703 200703
Count Value Count Value Count Value
Coupon1 2 10.5 3 15.4 9 21.4
Coupon2 5 2.3 10 12.8 16 16.7
Coupon3 7 8.4 2 4.3 16 12.7
I would like to Reference which Coupon, Type and Week in order to get a value:
Coupon1 Value 200702 15.4
Thanks in advance for your help,
Chad
Type & Coupon. I was wondering if there was a way to reference this data by
calling out these three identifiers.
Example:
200701 200701 200702 200702 200703 200703
Count Value Count Value Count Value
Coupon1 2 10.5 3 15.4 9 21.4
Coupon2 5 2.3 10 12.8 16 16.7
Coupon3 7 8.4 2 4.3 16 12.7
I would like to Reference which Coupon, Type and Week in order to get a value:
Coupon1 Value 200702 15.4
Thanks in advance for your help,
Chad