Hi All:
I'm trying to track delivery driver performance and want to see of the 5 trucks that left the yard last today, when was the last time they left last. I'm not concerned with how frequently they were last, just the last time.
The data I have lists the truck numbers (1-26) in columns B2-F82. The date of occurrence is in column G. I wanted the date of last occurrence for the truck in column B to populate in column H. C in I, D in J, etc.
I can do a vlookup on the truck number in B2 and have it return the date in H2, but can't do so for the trucks in C2-F2. (I'm running the vlookup un the data from B3:F82.
I'm stumped. I tried SUMIF, but that didn't work either. I though this would be a simple vlookup, but it isn't. Or I've missed something simple.
Thanks in advance
I'm trying to track delivery driver performance and want to see of the 5 trucks that left the yard last today, when was the last time they left last. I'm not concerned with how frequently they were last, just the last time.
The data I have lists the truck numbers (1-26) in columns B2-F82. The date of occurrence is in column G. I wanted the date of last occurrence for the truck in column B to populate in column H. C in I, D in J, etc.
I can do a vlookup on the truck number in B2 and have it return the date in H2, but can't do so for the trucks in C2-F2. (I'm running the vlookup un the data from B3:F82.
I'm stumped. I tried SUMIF, but that didn't work either. I though this would be a simple vlookup, but it isn't. Or I've missed something simple.
Thanks in advance
Last edited: