Issues referencing other sheets name manager

[steve89]

hello all this is the formula i have which works great which references a worksheet but i also need it to perform the same commands and keys but from another worksheet

IFERROR(INDEX(T_LEAVE56[TYPE OF UNIFORMS],SUMPRODUCT(--(T_LEAVE56[EMPLOYEE NAME]=$B9),--(T_LEAVE56[START DATE]<=C$8),--(T_LEAVE56[END DATE]>=C$8),ROW(T_LEAVE56[TYPE OF UNIFORMS]))-ROW(T_LEAVE56[#Headers])),"")

this above formula works perfectly but i also need it to reference T_Leave and T_Leave56. thank you so much

 

[Twollaston]

hello all this is the formula i have which works great which references a worksheet but i also need it to perform the same commands and keys but from another worksheet

IFERROR(INDEX(T_LEAVE56[TYPE OF UNIFORMS],SUMPRODUCT(--(T_LEAVE56[EMPLOYEE NAME]=$B9),--(T_LEAVE56[START DATE]<=C$8),--(T_LEAVE56[END DATE]>=C$8),ROW(T_LEAVE56[TYPE OF UNIFORMS]))-ROW(T_LEAVE56[#Headers])),"")

this above formula works perfectly but i also need it to reference T_Leave and T_Leave56. thank you so much

I'm not sure what you're asking, can you explain more? What cells exactly are you trying to reference from the sheet that is named T_Leave, and where did you want to apply it in this formula you posted?

 

[steve89]

i fixed it but need help with is formula please. In this example A2:A29 has shifts from AM1-AM4 and the rest are empty. heres the problem when the cells are empty it says "missing o" is there an error if formula to stop that as there are no missing shifts just empty cells? also a question if i have more then 1 of any shifts in this example "AM1" can it give a text saying more then 1 AM1

=IF(TEXTJOIN(", ",,IF(COUNTIF(F10:F52,'Employee Data'!$A$2:$A$29),"",'Employee Data'!$A$2:$A$29))="","","Missing: "&TEXTJOIN(", ",,IF(COUNTIF(F10:F52,'Employee Data'!$A$2:$A$29),"",'Employee Data'!$A$2:$A$29)))