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
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