I'm trying to show the most recent communication for vans in the shop.
The vans worksheet has a cell in column M for the most recent communication
There is a communication worksheet that has the unit number (which would relate to the vans worksheet), the date, and the summary of the discussion. One unit number could have many rows if communication is frequent or if we need to create a detailed "diary" of communication over time. But, generally speaking we just need to report the most recent communication. So, I'd like column M to capture the most recent summary of discussion for the unit number in that row.
Right now I am leaning towards a vlookup. If the communication worksheet were sorted by unit number ascending then date of communication decending the most recent will be the first one the vlookup hits when drilling down thru the unit numbers.
Anyone have an idea that might be better than that?
Bookmarks