Difference14
New member
- Joined
- Aug 2, 2014
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Can anyone help sort out this problem
Import C details deliveries to be made that day - sent in from another department.
Workbook "Monday Run" details the drivers run sheet (602 RS) and his load (602OL). If the site ID appears in Import C then a "C" is put in 602 RS column D, and the site ID in 602 OL B28:B40. A vlookup then puts the details from Import C into the respective column in 602OL (D28 to O40).
The problem occurs when a site has two or more orders for delivery that day - in this case both sites C062 and C070 have two deliveries each.
Is there any way to amend the formula to pick up the second delivery from Import C for these sites??
Any help would be appreciated.
Import C details deliveries to be made that day - sent in from another department.
Workbook "Monday Run" details the drivers run sheet (602 RS) and his load (602OL). If the site ID appears in Import C then a "C" is put in 602 RS column D, and the site ID in 602 OL B28:B40. A vlookup then puts the details from Import C into the respective column in 602OL (D28 to O40).
The problem occurs when a site has two or more orders for delivery that day - in this case both sites C062 and C070 have two deliveries each.
Is there any way to amend the formula to pick up the second delivery from Import C for these sites??
Any help would be appreciated.