I am trying to combine multiple MATCH functions with the IFS function. I need to see if a specific text appears in worksheet 1, 2, 3, or 4, and return "Sheet 1", "Sheet 2", "Sheet 3", or "Sheet 4". The entry below will poll and return "Sheet 1" just fine if the value is present, but returns N/A if value is on other sheets. 100 FG offered to a solution that works. I do not have to stick with IFS and Match.

=IFS(MATCH(E4,'Sheet 1'!$D$2:$D$301,0),"Sheet 1",(MATCH(E4,'ISheet 2'!$D$2:$D$301,0)),"Sheet 2")

I found a workaround using a created hidden tab to compile all the information into a single array.

Have you looked into a vlookup? This maybe could be a solution for your issue with some workarounds.