Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Indexing Function | Excel Worksheet Functions | |||
Indexing value fro each new worksheet | Excel Worksheet Functions | |||
Is Indexing the right option? | Excel Worksheet Functions | |||
excel formula/function woes | Excel Worksheet Functions | |||
Pivot table woes. | Excel Worksheet Functions |