Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup on 2 Values | Excel Worksheet Functions | |||
Summing lookup values | Excel Worksheet Functions | |||
How do I use vlookup with two lookup values? | Excel Worksheet Functions | |||
vlookup using two lookup values? | Excel Worksheet Functions | |||
Lookup values in one column to return another | Excel Worksheet Functions |