a forumula to look up a worksheet and pull information to a summary page

**cubeworker** · 11-03-2010, 05:09 PM

Hi
I am preparing a budget spreadsheet. It has a summary page and then a worksheet for each month.

Each month has formulas that pulls information forward into the next month.

I would like to write a formula on the summary page that

looks at cell "I2" on the summary page, which tells the summary what the current month is

then goes to that month's worksheet
and copies the year to date information from the current page to the summary page

so when I change the month in I2, it then updates to the next month's

so

on worksheet: summary L9

the formula looks at 'summary' I2

the months are 01, 02..12

so if the value is 06, it draws information from
worksheet 06, cell L9

when the summary I2 cell is change the next month to 07, it pulls from that worksheet

please and thank you

**davesexcel** · 11-03-2010, 07:19 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**Gary Brown** · 11-04-2010, 08:43 AM

You can use the formula Choose.

Therefore the formula would be =Choose(value('summary' I2),worksheet01!L9,worksheet02!L9,worksheet03!L9,worksheet04!L9.............worksheetNN!L9)

where NN is the last sheet number

Gary