In the spreadsheet below, I am wishing to obtain a result in the red box, in which it looks in that row for the location of the latest entry, and returns the date above (in this case, it should find "D/F" in column F and return the date 03/10/04.
I should then be able to drag the formula down for each row, so the result for row 6 would be 02/04/05.
Any Pprooners out there who can help?
