Thread: Indexing Woes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rianne Rianne is offline
external usenet poster
 
Posts: 7
Default Indexing Woes

I use =INDEX(range,match(cell,range,),match(cell,range,) ) formula to get
information from another worksheet/workbook daily. The problem comes from
data that is arranged like below, with multiple headings....How can I get it
to look up the information properly??


Provider1 Provider2
Age 2-3 years 4-7 years 8-12 years Overall 2-3 years 4-7 years 8-12
years Overall
Attribute1 74 43 16 36 74 43 16 36
Attribute2 2 2 2 2 2 2 2 2
Attribute3 4 8 14 10 4 8 14 10
Attribute4 2 6 11 7 2 6 11 7
Attribute5 3 6 5 5 3 6 5 5
Attribute6 5 7 6 6 5 7 6 6
Attribute7 1 3 5 4 1 3 5 4
Attribute8 6 18 32 22 6 18 32 22
Attribute9 3 7 8 7 3 7 8 7