find first instance of blank cell

[Sallylou92000]

I am setting up a spreadsheet to record payments in a work lotto.
Names of each participant are in a column, dates due are in the heading row.
As payment is made a Y is entered into the corresponding cell.
I would like to show when each person paid up to - my thinking was to use a formula to find the first blank cell in their row, and return the date from the heading row.
Sample attached - the cells I'm looking to populate are highlighted in yellow.
I have tired all sorts of formula's etc but can't get anything to work.
Thanks for your help
Sally

 

[Nebu]

Hi:

use the following array formula

=IFERROR(INDEX($K$1:$BP$1,1,MATCH(99^99,1/($K3:$BP3<>""))+1),$K$1)

Execute by pressing Control+Shift+Enter keys.

Thanks

 

[bosco_yip]

Try this (non-array formula),

=IFERROR(INDEX(K$1:BP$1,MATCH(1,INDEX(0+(K3:BP3=""),0),0)),"")

or,

=IFERROR(INDEX(K$1:BP$1,MATCH("zz",K3:BP3)+1),K$1)

Regards
Bosco

 

[Sallylou92000]

Perfect. Thanks so much. Makes the lotto money collection a little easier now.