With XLOOKUP you can do the same:
Formula: copy to clipboard
=XLOOKUP(TRUE,B1:$B$36<>"",B1:B$36,"nande",0)