I'm working in GoogleSheets and hoping to select the follow-up date most immediately following Today, and place that date in a cell which corresponds to the name in Column A of that same row.
My intuition tells me it has something to do with =HLOOKUP and =Today() functions, but beyond that I'm pretty lost.
Using you exact sample data: enter into B13 and fill down
=INDEX(B2:N2,1,MATCH(TODAY()+1,B2:N2,1)+1)