Hi

I have a couple of projects in which I'm tracking budgets for within multiple tables representing the month's weeks - 4 to 5 weeks - Section A area

From these tables or weeks, looking to make some linear burn rate types of charts - Section B area

How can I find the respective dates & projects & "drop in" the value amount given from Section A? From Section A, some cells are blank which is OK but in Section B, if respective date or project has no value, then have it represent the previous dates in puts across until new value is entered

Think I need VLookups or Index but not sure how to combine the multiple tables

See example file

Thanks

Attached Files

VLookup or Index Multiple Tables.xlsx (14.0 KB, 13 views)