Finding a blank cell and the value in the cell to the left

[CPBExcelnovice]

I would like to find the first blank cell and then the value in the cell to the left - i.e. "Tuesday".

The formula below finds the blank cell and returns the cell address $C$6

=CELL("address",INDEX(B5:D11,MATCH(TRUE,ISBLANK(C5:C11),0),2))

I was hoping to use the OFFSET function but it hasn't worked. Any suggestions?

[#2 · Accepted solution]

@CPBExcelnovice 

=INDEX(B5:B11,MATCH(TRUE,ISBLANK(C5:C11),0))

[#3]

Thank you so much...so simple! @Hans Vogelaar