=XLOOKUP(1,IF(ISERROR(MAKEARRAY(1,COLUMNS(C10:Q20),LAMBDA(rows,c,FILTER(OFFSET(C10:C20,0,c-1),OFFSET(C10:C20,0,c-1)=C4)))),0,1),C9:Q9)

That should work for what you're asking. It first finds the column with the desired date, then extracts the entry in row 9.

(Replace C4 with whatever other cells are needed.)