Header Name output

Hello,

Probably a nice easy request, but I am looking for a Formula that can lookup a client name then pull back the nearest date in the future to todays date and then return the column heading.

I hope if makes sense.

Try these array formulae (commit with Ctrl-Shift-Enter)

=MIN(IF(($A$4:$A$9=A15)*($B$4:$G$9>TODAY()),$B$4:$G$9))

=INDEX($B$3:$G$3,MATCH(MIN(IF(($A$4:$A$9=A15)*($B$4:$G$9>TODAY()),$B$4:$G$9)),INDEX($B$4:$G$9,MATCH(A15,$A$4:$A$9,0),0),0))

Hello Bob,

its work!!!!!

Thanks a lot!!!!!