Formula Support Issue

[Marhier]

Good afternoon, I hope you're all well.
At my work, half the users are on Excel 2013 and the other half are on Excel 2010.

On a spreadsheet I've created, I've used the following formula:

=IF(ISNUMBER(1/B10),B10*0.0622,IFNA(VLOOKUP(C10,Obex_Price_List,3,0),""))

This works fine for me on 2013, but when a 2010 user loads it up, the formula gets changed to:

=IF(ISNUMBER(1/B10),B10*0.0622,_xlfn.IFNA(VLOOKUP(C10,Obex_Price_List,3,0),""))

As I understand it, the _xlfn. error occurs when a particular formula isn't supported by a certain version of Excel?
I really thought this would be more of an issue with Excel versions pre 2007 and am surprised 2010 is giving me this error.

I was wondering if anyone can suggest how I change my formula to enable it to work on 2010, while still working in 2013?

All help is greatly appreciated, thank you.
Regards
Martin

[Marhier]

Ok... I think I solved it, lol.
I've changed it to:

=IF(ISNUMBER(1/B10),B10*0.0622,IFERROR(VLOOKUP(C10,Obex_Price_List,3,0),""))

Seems to have done the trick...

[mancubus]

As I understand it, the _xlfn. error occurs when a particular formula isn't supported by a certain version of Excel?

that's correct.

and IFERROR was the answer as you figured out.