excellence
Board Regular
- Joined
- Oct 5, 2005
- Messages
- 155
- Office Version
- 365
- Platform
- MacOS
Hi,
Two issues here:
I have an Office 365 Mac subscription and have noticed the xlookup function below, where it yields "NAME?".
I have also noted the threaded comment below (which appears instead of the normal comment section) which makes no sense to me as I have the latest version and concerned about losing comments I originally placed.
The blocked out website takes me to Bing.com and there are additional comments below the blocked area that I have entered previously and not included in the screenshot.
If I quit and reopen Excel sometime 1,2 or 3 times, Excel will open with the appropriate XLOOKUP function (without the _xfln.) and the "normal" comment section
I am at a loss as to what to do to be sure I don't lose data/functionality'
Thanks
=_xlfn.XLOOKUP(TRUE,B1:B3000<>"",B1:B3000,,,-1)
Two issues here:
I have an Office 365 Mac subscription and have noticed the xlookup function below, where it yields "NAME?".
I have also noted the threaded comment below (which appears instead of the normal comment section) which makes no sense to me as I have the latest version and concerned about losing comments I originally placed.
The blocked out website takes me to Bing.com and there are additional comments below the blocked area that I have entered previously and not included in the screenshot.
If I quit and reopen Excel sometime 1,2 or 3 times, Excel will open with the appropriate XLOOKUP function (without the _xfln.) and the "normal" comment section
I am at a loss as to what to do to be sure I don't lose data/functionality'
Thanks
=_xlfn.XLOOKUP(TRUE,B1:B3000<>"",B1:B3000,,,-1)