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)
ChannelCustomerSales CategoryInvoice NumbersInvoiced DatesDue Date Outstanding (Due)Distribution Fees – Convenience TotalTotal Pellissier IAC Beverage SalesIAC000369211-Aug30-Sep PdDistribution Fees – Convenience EngenEngen Garage – Spartan IAC Beverage SalesIAC000369615-Aug30-Sep PdDistribution Fees – Convenience TotalTotal Petroport N3 East IAC Beverage SalesIAC000016-Mar30-Mar PdDistribution Fees – Convenience TotalTotal Petroport N3 West IAC Beverage SalesIAC000016-Mar30-Mar PdDistribution Fees – Convenience BP ExpressBP Trompsburg IAC Beverage SalesIAC000000322-Aug30-Sep PdDistribution Fees – Convenience TotalTotal Petroport N3 East IAC Beverage SalesIAC000000428-Aug30-Sep PdDistribution Fees – Convenience TotalTotal Petroport N3 West IAC Beverage SalesIAC000000528-Aug30-Sep Pd
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)ChannelCustomerSales CategoryInvoice NumbersInvoiced DatesDue Date Outstanding (Due)Distribution Fees – Convenience TotalTotal Pellissier IAC Beverage SalesIAC000369211-Aug30-Sep PdDistribution Fees – Convenience EngenEngen Garage – Spartan IAC Beverage SalesIAC000369615-Aug30-Sep PdDistribution Fees – Convenience TotalTotal Petroport N3 East IAC Beverage SalesIAC000016-Mar30-Mar PdDistribution Fees – Convenience TotalTotal Petroport N3 West IAC Beverage SalesIAC000016-Mar30-Mar PdDistribution Fees – Convenience BP ExpressBP Trompsburg IAC Beverage SalesIAC000000322-Aug30-Sep PdDistribution Fees – Convenience TotalTotal Petroport N3 East IAC Beverage SalesIAC000000428-Aug30-Sep PdDistribution Fees – Convenience TotalTotal Petroport N3 West IAC Beverage SalesIAC000000528-Aug30-Sep Pd Read More
