Combining 2 Working Formulas Results in #NAME?

[meppwc]

In cell A2 of the “MAIN” worksheet, I am attempting to combine these 2 formulas together.
When I do, the formula returns “#NAME?”
I suspect my syntax is incorrect, can someone offer assistance?

FORMULA 1
=IFERROR(XLOOKUP(F2,'FMA TABLE'!D:D,'FMA TABLE'!E:E),"")

FORMULA 2
=IFERROR(XLOOKUP(F2,'SLNX TABLE'!D:D,'SLNX TABLE'!C:C),"")

FORMULA 1 AND 2 COMBINED
=IFERROR(XLOOKUP(F2,'FMA TABLE'!D:D,'FMA TABLE'!E:E),IFERROR(XLOOKUP(F2,'SLNX TABLE'!D:D,'SLNX TABLE'!C:C),””))

 

[Joe4]

Your combined formula seems to have slanted double-quotes, which Excel does not like. Try using straight up and down ones, i.e. change this:

=IFERROR(XLOOKUP(F2,'FMA TABLE'!D:D,'FMA TABLE'!E:E),IFERROR(XLOOKUP(F2,'SLNX TABLE'!D:D,'SLNX TABLE'!C:C),””))

to this:

=IFERROR(XLOOKUP(F2,'FMA TABLE'!D:D,'FMA TABLE'!E:E),IFERROR(XLOOKUP(F2,'SLNX TABLE'!D:D,'SLNX TABLE'!C:C),""))

 

[Fluff]

You can also use xlookup's in built error handling like

=XLOOKUP(F2,'FMA TABLE'!D:D,'FMA TABLE'!E:E,XLOOKUP(F2,'SLNX TABLE'!D:D,'SLNX TABLE'!C:C,""))

 

[meppwc]

Joe4, Fluff, thank you both so much. Everything is working as expected and I have learned A LOT from both of you.

 

[Fluff]

Glad we could help & thanks for the feedback.