| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
index-match function across different worksheets
Hi guys,
I have different worksheets to contain information from different years. To make it comprehensive, I have created a mastersheet which contains all the info across the worksheets. And once I make an entry in the worksheet, I hope the mastersheet can be updated automatically. the formula set is INDEX('2011-12'!K$4:K$7,MATCH(Master!$B5,'2011-12'!$B$4:$B$7,0),1). Yet, my problem is..... once I perform sorting in the mastersheet, the data are wrongly matched. So, I just wonder how I can revise the formula? Many thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/Match Formula across 2 worksheets | Excel Worksheet Functions | |||
| Help with Index / Match function | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match and index functions: corrlating data from 2 worksheets | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
