Forum Discussion
SurenBharadwaj
Jun 29, 2021Copper Contributor
Excel Lookup
Hi,
I have a table with multiple columns. One of these column contains names. Another contains dates. I have used the ISNUMBER search option along with the MAX function to find the latest date for a specified name in the table from the name column. The formula is as below.
=MAX(IF(ISNUMBER(SEARCH("Aaaa",Sheet1!$I$2:$I$500)),Sheet1!$J$2:$J$500)).
What I want to do now is return the value of another column in the same row from which the highest date value has been returned. Is this possible? If so, how?
Regards,
Suren
- Detlef_LewinSilver Contributor
Name Date Another Column Name Date Another Column Peter 06.05.2012 York Frank 15.10.2019 Paris Frank 15.10.2019 Paris Jack 23.01.2023 Home Frank 01.12.2013 Night Frank 17.04.2017 Ship Peter 23.04.2015 Horse Jack 06.10.2012 Hammer =MAXIFS($B$2:$B$8,$A$2:$A$8,F2) =FILTER($C$2:$C$8,($A$2:$A$8=F2)*($B$2:$B$8=G2))
- SurenBharadwajCopper Contributor
Thanks, Detlef. Will check this out.