Xlookup now available for all Excel 365 platforms

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

Xlookup is now available across all the Excel programs and apps, making it a viable alternative to Vlookup/Hlookup for Office 365 users.

The Xlookup function is the much-improved way to lookup values from a list or table.  It works really well but it’s taken some time to appear across all incarnations of Excel 365 and for all users, not just fast-track Insiders.

XLOOKUP cropped screengrab - Xlookup now available for all Excel 365 platforms

Source: Microsoft plus our cropping

That meant Xlookup was OK for solo use on a single computer but could be a compatibility problem if the workbook was shared to other devices or people.

Xlookup availability

Now Xlookup workbooks can be shared with any device using Excel 365:

  • Office 365 for Windows
  • Office 365 for Mac
  • Excel Online (browser based)
  • Excel for iPad/ iPhone
  • Excel for Android phone / tablets

The function is NOT available on any other version of Excel, including Excel 2019.

Check out our explanation of Xlookup including all the very useful improvements.

Go ahead and use Xlookup if you’re an Office 365 customer and anyone you’re sharing with is also on the Office 365 track.

Xlookup is coming and it’s truly a great thing

XLookup comes to Excel for iOS and Android

More Excel alternatives to nested IF statements

 

subs profile e1563205311409 - Xlookup now available for all Excel 365 platforms
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address