=_xlfn.XLOOKUP not working

[Dokman]

Hello,

I have Excel 2013 and this code is not working in 2013. Can someone help me. To change it so it's working in 2012

=_xlfn.XLOOKUP(E3;Mallen!C:C;Mallen!B:B;"Niet gevonden";0)

In Sheet1 in column E there is a number "2015105B" it's looks in sheet2"Mallen" in column C to that same number.
If the number is there, it's copy the info what's in column b stands. And put it in sheet1 in column G in the same row
as the number "2015105B" stands.

 

[RoryA]

XLOOKUP didn't exist in that version, so you need different functions. You could use:

=IFERROR(INDEX(Mallen!B:B;MATCH(E3;Mallen!C:C;0));"Niet gevonden")

 

[Dokman]

I still get the same error message "#NAAM?" I think there is something wrong in the string.
can you help me to solve the problem.

 

[Dokman]

RoryA

It's working. I have a dutch version of excel. So if you say =IFERROR that's for me =ALS.FOUT