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 ...
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.
AshaKantaSharma Beauty is in the simplicity. Thank you.
What syntax do i use when I am driving this query from another sheet? Do I put 'lookup value' before 'MAX' and then the 'table array' and so on? My 'lookup value' is my location value, and i seek to have the smaple number selected.