Thread: Help with filling in data based on dates

I am attempting to fill in data on one tab that is based on a date (Month and Year). THe data is pulled in from the web and I believe a formatting issue is preventing a vlookup from working - any ideas? The Price for 12 mo period is where I want to enter the desired start date and the actual data is on the Price by date tab. I've added notations that help to explain on the attached, you can ignore the other tabs.

Hi

Try this. All references are to the sheet Prices for 12 month period.

D1: =MATCH(B1,'Price by Date'!A:A,0)
A4: =INDEX('Price by Date'!A:A,'Prices for 12 month period'!$D$1+ROW()-4)
B4: =INDEX('Price by Date'!B:B,'Prices for 12 month period'!$D$1+ROW()-4)
C4: =INDEX('Price by Date'!C:C,'Prices for 12 month period'!$D$1+ROW()-4)
D4: =INDEX('Price by Date'!D:D,'Prices for 12 month period'!$D$1+ROW()-4)

Copy from A4:D4 down to A15:D15

HTH

rylo

I can get the program to work one time, after that it will not update the dates if I change the month in B1 and if I close the program and re-open it wants to update links that do not work. I had to link each formula to the spreadsheet and then specifically the Prices for 12 month period tab in order to get them to work the first time. It doesn't seem to matter if I enter the formula's as arrays (Ctrl-Shft-Entr) or not, should I? The attached contains the formula's.

I genuinely apprecaite your help thus far, Any suggestions?

Rylo - after I posted this morning I re-opend the program, fixed the link again and now the program appears to work just fine - I am not sure what is or was going on but it is working - thanks!