Unanswered: Look up a value by a concatenated referrence?
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?.