We are having a problem in our billing where we hire fleet to other departments, and the data entry person is sometimes not matching up the start and end hours.
The issue is that the asset number may not necessarily be in order (e.g. may be multiple entries before i need to match up the start/end hours).
I would love to attach a picture, but im not sure how but i will try to explain..
A2 = Docket number (1234) Manual Entry
B2 = Asset Number (78360) Manual Entry
I2 = Start hours (1311.3) Manual Entry
J2 = End hours (1324.4) Manual Entry
in column B there could be 20 entries of asset numbers, some could be the same as B2, but then not all of them will be.
I want a formula which when i'm entering in A/B as new charge/docket, i want it to look up and see if there is the same asset number, if there is, i want it to look in column J to give me the end hours so that i can match what i am entering in I.
Ideally this would be in another column (say X), so that i can do conditional formatting so to say that if X doesnt match I, then highlight in red, as obviously it doesnt match up and we have some hours that we are missing, or a docket that hasnt been charged...
I hope this makes sense, let me know if you need more information.