Hey all, I need to alter an index/match formula to work with rows instead of columns.
Here is the original formula:
=INDEX('Loads'!AL3:AL185,MATCH(A3,'Loads'!A3:A185,FALSE),1)
below are the 2 examples of where I need to put the new formula and where it needs to look.
So, what I am trying to do is match the name in column "I" (the abreviated name) and the determining code (i.e. "pu" or "del") with the name and determining code in another worksheet, then give the total at the bottom of the sheet.
So that if the formula is for the loads picking up the formula looks for abriceno, then pu, then gives the total at the bottom of that column.....???
I am going to start hammering at this trying to see if I can figure it out, maybe a dual match... not sure yet, but if any of you have any thoughts, let me know.
bk
Here is the original formula:
=INDEX('Loads'!AL3:AL185,MATCH(A3,'Loads'!A3:A185,FALSE),1)
below are the 2 examples of where I need to put the new formula and where it needs to look.
Month End Compilation Report.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
45 | DaveCrosby'sTeam | TotalLoadsPickedUpYesterday | TotalPickupsLateYesterday | PickupOntime% | ||
46 | ||||||
47 | Benefiel,Krissa | 1 | 1 | 0.0% | ||
48 | Bowker,Dave | 1 | 1 | 0.0% | ||
49 | Briceno,Alma | 1 | 1 | 0.0% | ||
50 | Crooks,Holly | 1 | 1 | 0.0% | ||
Printable Report |
Month End Compilation Report.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
81 | Abriceno | Abriceno | Acontreras | Acontreras | Aoverby | Aoverby | |||
82 | PU | Del | PU | Del | PU | Del | |||
83 | 1 | 5 | 8 | ||||||
84 | 2 | 5 | 5 | ||||||
85 | 3 | 47 | |||||||
86 | Totals | 6 | 5 | 5 | 47 | 8 | 5 | ||
Actual Late Loads |
So, what I am trying to do is match the name in column "I" (the abreviated name) and the determining code (i.e. "pu" or "del") with the name and determining code in another worksheet, then give the total at the bottom of the sheet.
So that if the formula is for the loads picking up the formula looks for abriceno, then pu, then gives the total at the bottom of that column.....???
I am going to start hammering at this trying to see if I can figure it out, maybe a dual match... not sure yet, but if any of you have any thoughts, let me know.
bk