Skip to content

XLookup comes to Excel for iOS and Android

Xlookup, the vast improvement on Vlookup/Hlookup is now available on Excel Mobile for iOS (iPhone/Ipad) and Android.

This is great news because it means Office 365 Windows/Mac workbooks can be fully compatible with Excel on mobile devices.

You can create or edit formula with XLookup() and refresh existing data that uses the function.

Xlookup on Excel for iOS (left) and Android (right). Source: Microsoft

Xlookup Mobile availability

For the moment it’s just ‘Insiders’ getting the advance look but it’ll become widely available in a month or two (fingers crossed).

Look for this or later Excel Mobile versions …

Apple iOS, iPhone and iPad: Version 2.34 (20012701)

Android: Build 16.0.12527.20026

Or just try entering =Xlookup in an empty cell, if the function appears in the autocomplete list, you’re good to go.

Xlookup is coming and it’s truly a great thing

More Excel alternatives to nested IF statements

 

About this author

Office-Watch.com

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.