automatic posting in column

Question

I have a spreadsheet that I am trying to post figures from one column into columns with same name.&nbsp; Example of column names Name:&nbsp; Spent - H Pymt -&nbsp;Utilities - dog expense -&nbsp; I have one column Named Payee (Under Payee are the same names that are on my column names&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,215.36&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Utilities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 151.46&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dog Expense&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&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;&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;&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 385.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;What I want it to do is if Colum title is the same as Payee Row I want the amount in the spent column automatically go in to row that matches.&nbsp; I hope you understand what I am trying to ask.Thank you in advance&nbsp;

oliverscheurich · Answer

PamM2565&nbsp;=IFERROR(INDEX($C$3:$C$12,,MATCH(E$1,$A3,0)),"")Maybe with this formula.&nbsp;

Forum Discussion

automatic posting in column

Share

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