Re: Excel Query

Use XLOOKUP() with BYROW() function like

=BYROW(E5:G23,LAMBDA(r,TEXT(XLOOKUP("z",r,$E$4:$G$4,,-1,-1),"d")))

Only XLOOKUP() in this way-

=TEXT(XLOOKUP("F",E5:G5,$E$4:$G$4,,,-1),"d")

Or-

=TEXT(XLOOKUP("z",E5:G5,$E$4:$G$4,,-1,-1),"d")

See the attachment