Date from a row that corresponds to the first cell containing a value in another row (Google Sheets)

[salange]

Hi all - this spreadsheet is for tracking volunteers at a wildlife center. I need a formula that returns the first date that a volunteer showed up this year. Each cell from BN7 down and right contains the number of hours that each vol worked on each day. So basically, for each vol, I need a formula that returns the date in row 5 that corresponds with the first non-blank cell for that vol past BN. Dylan should return 1/3, Sarah and Irfan should return a blank or an error or whatever, Casey should return 1/7, etc.

I think it should involve ARRAYFORMULA and maybe SORT but past that I'm pretty stumped. Any help would be much appreciated - thanks!

 

[salange]

I figured it out with help from a reply on the Excel forum, but in case anybody comes across this:

=ARRAYFORMULA(INDEX(BN$5:PN$5,MATCH(FALSE,ISBLANK(BN7:PN7),0)))

 

[RoryA]

I figured it out with help from a reply on the Excel forum

A reminder then: Message Board Rules