Forum Discussion
look up and select most recent date from list
Hello DonPollockTC
I have used =VLOOKUP(MAX(A:A),A:B,2,FALSE)
to find out most recent location. See the attached data.
Hope it what you are searching for.
OK thanks. I was not clear enough with my question. I was seeking to select, for a selected location value (column 1), the sample number (coumn 2), for the m ost recent sampling recorded for all sites (column 3). This query is driven from a separate sheet and looking to put a single value, the sample number, into a cell on that separate sheet. I was not looking to list most recent dates alongside the existing data table.
My solution appears to be MAX(VLOOKUP($A8,'TEST DATA'!B$4:H$67,4,FALSE)) where column '4' holds the sample numbers and column 5 holds the relative date.
Cheers and thanks for succinct and prompt responses. Don