Forum Discussion

Jeffvd671860's avatar
Jeffvd671860
Copper Contributor
Jun 10, 2024

Return a value from a reference based on multiple Columns

Could someone please guide me   I am trying to formulate the data below on a seperate sheet, by looking up the Channel, by Due date and return the value (outstanding Due) Channe...
excel
Formulas and Functions
Jeffvd67's avatar
Jeffvd67
Copper Contributor
Jun 10, 2024

Martin_Angosto Thank you, however im trying to pull the total values from Column Outstanding Payments, these might be paid up of have multiple values by month. I will try your suggestion 

Jeffvd67's avatar
Jeffvd67
Copper Contributor
Jun 10, 2024

Martin_Angosto 

I have refreshed the spreadsheet and tried to breakdown the following: 

 

I am trying to pull the values by month for each Customer.  This will be on a seperate sheet hence Sheet 1 and sheet 2

 ABCDEFGH 
1SHEET 1        
2CustomerChannelSales CategoryInvoice NumbersInvoiced DatesDue DateOutstanding (Due)Invoiced 
3BP, FourwaysDistribution Fees - Convenience TotalIAC Beverage SalesIAC000369211-Aug30-Jul3,598.493,598.49 
4Engen Garage - SpartanDistribution Fees - Convenience EngenIAC Beverage SalesIAC000369615-Aug30-May1,347.311,347.31 
5Total Petroport N3 EastDistribution Fees - Convenience TotalIAC Beverage SalesIAC000016-Mar30-JunPd1,195.54 
6Total Petroport N3 WestDistribution Fees - Convenience TotalIAC Beverage SalesIAC000016-Mar30-Apr2,391.082,391.08 
7BP TrompsburgDistribution Fees - Convenience BP ExpressIAC Beverage SalesIAC000000322-Aug30-Sep2,918.492,918.49 
8         
9Sheet 2        
10Income        
11Distribution Fees - Convenience BP ExpressCustomer Sales Income31-Jul #N/A    
12Distribution Fees - Convenience EngenCustomer Sales Income31-Jul -    
13Distribution Fees - Convenience PnP Direct StoresCustomer Sales Income31-Jul -    
14Distribution Fees - Convenience SasolCustomer Sales Income31-Jul -    
15Distribution Fees - Convenience TotalCustomer Sales Income31-Jul -    
          
          
        

 

Resources