Forum Discussion
CPBExcelnovice
Feb 06, 2022Copper Contributor
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?
2 Replies
- CPBExcelnoviceCopper Contributor
Thank you so much...so simple! HansVogelaar