Automatic posting of numbers to correct column based on column heading and row titles

Question

Can someone please tell me how the $ amounts in Spent Colum can automatically be posted in the column that matches payee name in the rows.&nbsp; &nbsp; I cannot get it to work.&nbsp; Thank you so much.&nbsp;PAYEE&nbsp;DEPOSITS&nbsp;&nbsp;SPENT&nbsp;&nbsp;BALANCE&nbsp;H PymtUtilitiesDog ExpenseComputerInsuranceDoctor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;H Pymt&nbsp;&nbsp;&nbsp; 2,215.36&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Utilities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 151.46&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dog Expense&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 114.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Computer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Insurance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 87.99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Doctor&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 385.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

riny_van_eekelen · Accepted Answer

PamM2565&nbsp;You didn't specify the Excel version you work with, so I've included two possible solutions in the attached file. One with a single dynamic array and one a regular formula copied down and across.&nbsp;&nbsp;

Forum Discussion

Automatic posting of numbers to correct column based on column heading and row titles

2 Replies

Resources

PAYEE	DEPOSITS	SPENT	BALANCE	H Pymt	Utilities	Dog Expense	Computer	Insurance	Doctor

H Pymt		2,215.36
Utilities		151.46
Dog Expense		114.00
Computer		25.00
Insurance		87.99
Doctor		385.00