look up column according to today's date

[allison15]

I am trying to put a report together that feeds from others and will be updated monthly somewhat automatically.
My spreadsheet will be the result of other workbooks in the same folder being updated monthly and feeding into it. Some of the reports I am using add a new column on for each month. I want my spreadsheet to pull only the present month from the report without having to update the formulas monthly.

The months as new columns are created are added to the new columns as the first of that month (9/1/10). As of now I have written a formula that will return the first day of the current month.(=TODAY()-DAY(TODAY())+1)) Now I am trying to figure out how to scan the row for the current month and return the corresponding column to my spreadsheet.

In other words, the top row of a spreadsheet is the first day of the month. I want the column below the first day of the present month to feed into another workbook without updating the formulas every month.
I hope this is clear enough
Thanks!

[JBeaucaire]

If the dates are ascending properly from left to right, you can use a fuzzy MATCH() command on row1 to get the column number of the current month:

=MATCH(TODAY(), Sheet1!$1:$1, 1)

It's the 1 at the end that makes the match to the first day of the current month.

Now that you have the correct column Number, use that to adjust your lookup formulas in the other workbook.

[allison15]

Sorry I'm not really understanding what you are suggesting. I have attatched an example to better explain my problem. I want the column corresponding to the present month (whatever that may be) in sheet 2 to insert itself automatically in column B on sheet 1. The information on sheet 2 will be updated monthly.
Sorry to be a pain! Thanks for all your help!

[JBeaucaire]

Put this in B5 and copy down.

=INDEX(Sheet2!$B$4:$G$6, MATCH($A5, Sheet2!$A$4:$A$6, 0), MATCH(TODAY(), Sheet2!$B$3:$G$3, 1))