This is what im using & i keep getting a REF error C5 is on a total different
worksheet & im looking for numbers in the other 52 worksheets to match with C5

EXAMPLE the 52 worksheets will be clock # entered for overtime if worked in
columns AR,AS,AT,AV,AW,AX,AZ,BA,BB & the sheet im working on C column will
have clock # for people who have employment here. E, F column on same
worsheet is what im using TO LET ME KNOW if refused or worked overtime so
hours can be calculated. I have tried a lot of different combinations but
can,t get it to work

=IF('Week 1:Week 52'!AR6=C5,($C5),"")