Forum Discussion
look up and select most recent date from list
This can also be achieved by MAX IF function which is accomplished by VLOOKUP.
I have enclosed the work done on data shared.
ShishirKumar I now see that my proposed solution is also flawed. Continuing to work on your suggestions.
ShishirKumar 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
