View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chad chad is offline
external usenet poster
 
Posts: 273
Default Referencing 3 values for a lookup

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