VLookup or Index Multiple Tables

[mycon73]

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

[mycon73]

Hi Group,

Can anyone assist with this?

Thanks for the assistance

[Pecoflyer]

Please be patient. Free forums provide free help. You cannot expect volunteers to be waiting behind their screen to answer questions rapidly.
It is customary to wait at least 24 hrs before bumping.
If you are in a hurry, there are many paying sites around.
Thanks

[NBVC]

Try this formula in P16, copied down and across.


=SUMPRODUCT(($D$12:$J$40=P$15)*($C13:$C41=$N16),$D 13:$J41)

[mycon73]

NBVC

This works great!!

Thanks for the assistance