Forum Discussion

CPBExcelnovice's avatar
CPBExcelnovice
Copper Contributor
Feb 06, 2022
Solved

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

 

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?

 

Resources