Forum Discussion
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...
See attached workbook with proposed solution.
=IFERROR(INDEX(Sheet1!A2:G8,MATCH(1,(Sheet2!B2=Sheet1!A2:A8)*(Sheet2!B3=Sheet1!F2:F8),0),7),"Not found")
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
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
A B C D E F G H 1 SHEET 1 2 Customer Channel Sales Category Invoice Numbers Invoiced Dates Due Date Outstanding (Due) Invoiced 3 BP, Fourways Distribution Fees - Convenience Total IAC Beverage Sales IAC0003692 11-Aug 30-Jul 3,598.49 3,598.49 4 Engen Garage - Spartan Distribution Fees - Convenience Engen IAC Beverage Sales IAC0003696 15-Aug 30-May 1,347.31 1,347.31 5 Total Petroport N3 East Distribution Fees - Convenience Total IAC Beverage Sales IAC0000 16-Mar 30-Jun Pd 1,195.54 6 Total Petroport N3 West Distribution Fees - Convenience Total IAC Beverage Sales IAC0000 16-Mar 30-Apr 2,391.08 2,391.08 7 BP Trompsburg Distribution Fees - Convenience BP Express IAC Beverage Sales IAC0000003 22-Aug 30-Sep 2,918.49 2,918.49 8 9 Sheet 2 10 Income 11 Distribution Fees - Convenience BP Express Customer Sales Income 31-Jul #N/A 12 Distribution Fees - Convenience Engen Customer Sales Income 31-Jul - 13 Distribution Fees - Convenience PnP Direct Stores Customer Sales Income 31-Jul - 14 Distribution Fees - Convenience Sasol Customer Sales Income 31-Jul - 15 Distribution Fees - Convenience Total Customer Sales Income 31-Jul -