Forum Discussion
look up and select most recent date from list
what function can I put into a cell to select the sample number with most recent date when using VLOOKUP to select a location code? I cannot take these away and run a sort in a separate spreadsheet ...
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.