Index/Match Formula Returning N/A

[hconn]

Hi,

I'm creating a cashflow spreadsheet to track the outgoings from various sources and have used an index match formula to track from different projects into one summary sheet. The formula works fine for the BACS column, but for my CC and ACC columns it returns a #N/A. Can anyone help with solving my formula issue as it has been plaguing me for days now! Attached is the first image that is the summary page with the errored formula and the second image is the source sheet.

Thanks,
Harry

 

[awoohaw]

Not sure what you're trying to accomplish here. The grids look identical except for some row headers (that reference information that isn't defined anywhere else).

 

[hconn]

Not sure what you're trying to accomplish here. The grids look identical except for some row headers (that reference information that isn't defined anywhere else).

The ultimate goal is to have multiple tabs (one for each project) and for the values of each spend type to pull through to the summary page. The dates of each project will change so I'm trying to use the index match to pull through the data for each week into the summary page underneath the relevant week

 

[awoohaw]

I still need your help.

(that reference information that isn't defined anywhere else).

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Index Match Formula Returning Incorrect Values
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[6StringJazzer]

Answer posted in cross-linked site. The problem is the dates are in merged cells.