Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Indexing Function MCDST070-271 Excel Worksheet Functions 0 June 29th 06 08:50 PM
Indexing value fro each new worksheet Corey Excel Worksheet Functions 0 June 22nd 06 12:40 AM
Is Indexing the right option? Shaun Martin Excel Worksheet Functions 4 May 17th 05 09:16 AM
excel formula/function woes Domenic Excel Worksheet Functions 0 March 19th 05 10:57 PM
Pivot table woes. Kevin M Excel Worksheet Functions 0 January 6th 05 04:03 PM


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"