Excel cash book: formula to duplicate amt in relevant exp column

[quilta]

Cash book: what formula would work to duplicate an amount in one (total
expense) column, to the relevant expense column, using a simple chart of
accounts/code number to identify which expense.

 

[Pete_UK]

Imagine you have data laid out like this in row 1:

Date Descr Amount Code 1001 1002 1003 etc.

You enter data into the first 4 columns. Then in E2 you can have a formula
like this:

=IF($D2=E$1,$C2,0)

Copy this across the row for as many columns as you need, then copy all
these formulae down for as many rows as you need.

Hope this helps.

Pete