index-match function across different worksheets

B

breezetong

Hi guys,

I have different worksheets to contain information from different years
To make it comprehensive, I have created a mastersheet which contain
all the info across the worksheets. And once I make an entry in th
worksheet, I hope the mastersheet can be updated automatically. th
formula set i
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 dat
are wrongly matched. So, I just wonder how I can revise the formula
Many thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match/Index/Sum function with date range 2
Index Match function for lookup HELP 5
HELP: IF Statement between Dates for Reverse Index failing 0
Formula: Counting Cells on Different Worksheets 3
Wildcard issue for Index/Match Function when searching numbers 1
Index / Match Formula Problem 4
Return value from a Two Variable Data Table with Dates 1
Index and Match 8

Top