IFS with Xlookup not working as it should

[ecrodrig]

So I have the following formula:

By themselves, they work as they should:

=XLOOKUP(A3,('Sheet1'!$A$A,'Sheet1'!$C$C,"Not Found")
=XLOOKUP(A3,('Sheet2'!$A$A,'Sheet2'!$E$E,"Not Found")
=XLOOKUP(A3,('Sheet3'!$A$A,'Sheet3'!$C$C,"Not Found")


Once I add them to an IFS statement I get #N/A Obviously I am missing something in my formula.

=IFS(XLOOKUP(A3,('Sheet1'!$A$A,'Sheet1'!$C$C), XLOOKUP(A3,('Shee2'!$A$A,'Sheet2'!$E$E), XLOOKUP(A3,('Sheet3'!$A$A,'Sheet3'!$C$C), "Not Found")


Any help would be appreciated. Thanks

 

[Alex Blakenburg]

Just curious are you running MS365 on the Windows machine and installing the updates ?
What do you see if you type = let into a cell, does it recognise it ?

 

[ecrodrig]

Just curious are you running MS365 on the Windows machine and installing the updates ?
What do you see if you type = let into a cell, does it recognise it ?

Yes, Filter isn't working on my Mac. Note that in order to use Xl2bb I need to send the file from my windows machine (my work laptop) to my MAC (my personal PC) because my work laptop won't allow the macros to run for security reasons. All the commands were fine on my windows but something is funky on my Mac when it comes to the filter command. BTW sorry to respond so late I have been away. Thanks!