XLOOKUP xfln

[excellence]

Why does Excel put in xfln in front of my lookup formula occasionally and return #NAME?

=_xlfn.XLOOKUP(TRUE,B1:B3000<>"",B1:B3000,,,-1)

Doesn't always do it.

Version 16.84 (24041420) for Mac

Many thanks

 

[Cubist]

See if you can find an answer from MS forum.

Edit: This thread looks useful.

 

[excellence]

thx for your help