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

[Mark McInerney]

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.

 

[RoryA]

XLOOKUP was introduced with 365 as far as I know. It definitely is not in 2016.

 

[Mark McInerney]

AAAAhhhhhh.....**** - great formula...but a whole lot of recoding to do now. Thanks for confirming.