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, 11 views)

Hi Group,

Can anyone assist with this?

Thanks for the assistance

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

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Try this formula in P16, copied down and across.


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

NBVC

This works great!!

Thanks for the assistance