.xlfn error Office 365 v 2019 Home and Student - Xlookup

Mark McInerney

Board Regular
Joined
Apr 4, 2012
Messages
204
Hi All,

I understand that the .xlfn errors occur when an older version of Excel is being used to try and run formulas from the newer version. I am having trouble with xlookup.

The errors are coming back from a 365 version of Excel v a 2019 Home and Student version.

I checked when xlookup was availlble, and it looks like it was 2016? Am I getting something else wrong on this?

Any help greatly appreciated.

Best - Mark.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,811
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
XLOOKUP was introduced with 365 as far as I know. It definitely is not in 2016.
 

Mark McInerney

Board Regular
Joined
Apr 4, 2012
Messages
204
AAAAhhhhhh.....**** - great formula...but a whole lot of recoding to do now. Thanks for confirming.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,523
Messages
5,572,639
Members
412,478
Latest member
MakeItWorkVBA
Top