I need some help with an Excel sheet I am working on. In the attached spreadsheet, I am trying to get the values in column B and D into columns G, H, I and J. I will explain.
In the left hand most column are printer serial numbers. These printers have readings in either black or colour. Sometimes only black though and no colour. I need to be able to lookup the serial number of a printer, determine whether i am looking for the values for black or colour and then copy the values into the associated cells.
So for serial number JWF96125, there is a reading for black. I need the value in column C (Last Reading) to then be copied into column G (mono start reading). I also need column E's reading in that instance to be copied into column H of that same row.
That same serial number though, also has a colour reading. So now the value in column C (last reading) for the associating row has to be copied into the same row in column I. Then the value in column E for that row will need to be copied into column J.
I've done an example so you can see by filling out cells G2-J2. But i had a hard time using Vlookups due to the variations in values and really could do with your help.
Any questions, let me know. Hope it makes sense.
Thanks for helping