I have a formula that I was trying to use to get the newest date, but it only gives me the first date for the closest to zero client number that it has. I'm looking for the newest date for any client number on the named range of JUDI9 =IFERROR(LOOKUP(9.99999999999999E+307,MATCH(INDEX(Table_Query_from_GJ,0,1),JUDI9&"",0),INDEX(Table_Query_from_GJ,0,3)),N682)
Solved by A. D. in 28 mins