Formula works in some cells but not others

[pzh20]

i'm really struggling with a formula that seems to work in some cells and not others.
I have a table of bank transactions. Income is from clients and outgoings are from suppliers as well as charges etc.
Each supplier and customer are assigned a 'category' that matches a column of the sheet.
My formula is trying to populate the matched columns with the income or outgoings as a breakdown of the transactions.
the pseudo code is as follows;
1, If the transaction is income, lookup the customer from the customers table
2, extract the category
3,if the category matches the column heading, copy the transaction total to the column, otherwise leave blank,
4, assuming the transaction is not income
5, lookup the supplier from the suppliers table and extract the category from the supplier
6, if this category matched the column title, copy the transaction total into the cell.
The formula is copied to all the cells in the sheet covering the categories.
It works in some cells and not in others which is what i'm struggling with.
attached is a screenshot of the formula in the cells showing it working and not. There are also screenshots of the customer/supplier tables.
I hope this is enough info for suggestions of what I should try.

 

[awoohaw]

Many times formulas are correct but your data maybe of the wrong data type. By posting an image the forum cannot use your data to examine your problem.
Mr. Excel has a tool called xl2bb add in (link below) that allows users to post mini worksheets of your data.
But, what is more important the forum does not have to manually recreate your scenario, which can have errors in entry as well as assumptions.
So, please help the forum help you and use the add in. If you cannot use it, then post your data as a table, not an image.

All that being said. Have you debugged each conditional statement in formula in the cells that are not calculating as expected?

And to help the forum best help you, please state what version of excel you are using and also update your profile so that the version appears on your button (so next time the forum will know). This is because many solutions may not work on different versions of excel.

 

[pzh20]

Thanks for the pointer to the mini sheet, I'll see if I can create one. I've been through it so many times I am getting rather foggy. I'll follow it through again just to see if the data is wrong rather than the formula (must admit up until now I've only visually checked).

 

[pzh20]

Turns out my formula was correct, and the copy'd pasted text was wrong.
Thanks for pointing me in the right direction.

 

[awoohaw]

Your welcome.

Best Wishes!