Posted by Corey on September 17, 2001 2:18 PM
I have two sheets in a workbook. The first, Budget, has two years of budget information (each column representing a month). The second sheet Summary will capture only one month of information, based on the month selected.
I would like to be able to input a period (date) in a fixed cell (C2) of the Summary sheet and have that months budget information flow into this sheet.
The Budget sheet has the date (value to be matched) in row 1 and the data I want to extract in row 10. Because of the layout, I do not think I can do this with lookup. Any suggestions on how I can make this work?