i need to have this formula include all my worksheets and not just the 1-7-11 =IF(ISNUMBER(MATCH(A1,'1-7-11'!$A:$A,0)),"P","")
i have multiple worksheets that each worksheet is less than 100 rows. my worksheets go from 1-7-11, 1-14-11, 1-21-11, etc.. for each 7 days all the way up to 12-30-11. my formula works great for the one worksheet but i need it to look at every worksheet. is this possible?