My question is complicated. But here it goes...
On the worksheet "Delivered Cars," I have the VIN numbers of different cars in column G.
On the worksheet, "Lease-end," I have the VIN of all the returned cars in column B. On the same worksheet, I have the reason why they were returned in column G. There are 4 reasons why they are returned: early term, reg term, purchased, and insured.
On the "Delivered Cars" worksheet I would like to have a new column entitled "Returned Units." I want the VINs on this sheet to reference the Lease-end sheet. If the VIN is found on the Lease-end sheet, I would like it to show why it was returned in the return column (with on of those four options) of the Delivered Cars worksheet. Not all VINs would be found on the "Lease-end" worksheet. For those, the "returned units" column would be blank.
As an extra feature, I would like for the rows on the "delivered cars" worksheet to be highlighted in blue if they have been returned at all. So, if the row wasn't highlighted, this means it has yet to be returned.
That's it. I need the brilliance of an Excel Master!
Much thanks!