I have a spreadsheet with one summary worksheet and multiple worksheets, one for each month of history. I would essentially like to lookup a value in one of the monthly worksheets depending upon a month and year cell that can be populated in the summary sheet.

To simplify, imagine I have each monthly worksheet tab numbered according to the month (1 for January, 2 for Feb, ...etc). On my summary sheet, there is a cell in which I can enter the month number I want, say I enter 1. I would like to lookup a cell B5 from the month I specified (1 or January). I've tried concatenating a dynamic referrence so that it looks up the value on the sheet number I specified in the control cell but it seems like this only yields a text version of the variable. Is there another lookup type function to do this?.

Thanks,

Joshua

Hi Joshua,

Let's say in Summary!B2 you have a number from 1 to 12.
Let's also say that you have worksheets in the same workbook called January, February etc...

To get the value from cell A1 on the relevant month worksheet, you could use a formula such as this:
Note that INDIRECT() is volatile.

Hope that helps...

Colin,

Cool, thanks. That seems simple enough.

Joshua