Forum Discussion

Peter_Browning's avatar
Peter_Browning
Copper Contributor
Nov 24, 2023

Help with Formula

I have a set of data like this:   Reference     Code               Type 12502           FR19511107    Salary 12502           FR19511101    NI Conts 12502           FR19511161    Call Out 12502 ...
excel
Formulas and Functions
steve_luke's avatar
steve_luke
Copper Contributor
Nov 25, 2023

Peter_Browning Can you assist me in creating a formula that works

 

I want to enter a name in one cell.  Once the name is added then the amount owed to auto populate the amount owing into another cell.  When I change the name, the amount moves to the owing cell.  This sound stupid.  I hope my picture helps.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Resources