Trying to get the first blank in a range and pull data from another cell in that row

[RHeller]

For instance I get the cell address of $P$119 but I need the data from $A$118

=CELL("address",INDEX(P104:P133,MATCH(TRUE,ISBLANK(P104:P133),0))) this is where I get the $P$119 result but need the data
from $A$118 (the last date data was entered).

Column A contains dates and column P shows where data has been entered up to.

Any help is appreciated, I'm new to this forum.

 

[RHeller]

 

[Alex Blakenburg]

Are you sure you don't just want something like this:

=XLOOKUP(TRUE,($P$104:$P$133<>""),$A$104:$A$133,"",0,-1)

 

[RHeller]

=XLOOKUP(TRUE,($P$104:$P$133<>""),$A$104:$A$133,"",0,-1)

YES! That works perfectly for what I need, thank you so much. I then pull that cell into my Monthly Forecast. Have a nice day, thanks again.

 

[Alex Blakenburg]

You're welcome. Glad I could help.