the date isn't the newest date in the column

[Dark0Prince]

 =IFERROR(LOOKUP(9.99999999999999E+307,MATCH(INDEX(Table_Query_from_GJ,0,1),JUDI9&"",0),INDEX(Table_Query_from_GJ,0,3)),N682)

IIt's pulling the date for the right client number but it isn't the newest date for that named range

 

[Dark0Prince]

EDIT: It's pulling a correct date for the client number closets to the number 1 but it isn't the newest date for that named range

I want to pull the newest date no matter what the client number is, but instead it finds a client number that is closest to the number 1 and uses that date instead of the newest date for any client number in the named range JUDI9

 

[Dark0Prince]

Problem solved Since i'm using a lookup I needed to sort my data in the right order.