Here is the formula I am using at the moment: {=IF(ISERROR(IF(NOT(($S2<=INDEX('101008'!B$5:Q$40,MATCH($V2,'101008'!Q$5:Q$40,0),1)+INDEX('101008'!B$5:Q$40,MATCH($V2,'101008'!Q$5:Q$40,0),7))*($S2>=INDEX('101008'!B$5:Q$40,MATCH($V2,'101008'!Q$5:Q$40,0),1)-INDEX('101008'!B$5:Q$40,MATCH($V2,'101008'!Q$5:Q$40,0),7))),"x","")),"",IF(NOT(($S2<=INDEX('101008'!B$5:Q$40,MATCH($V2,'101008'!Q$5:Q$40,0),1)+INDEX('101008'!B$5:Q$40,MATCH($V2,'101008'!Q$5:Q$40,0),7))*($S2>=INDEX('101008'!B$5:Q$40,MATCH($V2,'101008'!Q$5:Q$40,0),1)-INDEX('101008'!B$5:Q$40,MATCH($V2,'101008'!Q$5:Q$40,0),7))),"x",""))}.
It looks worse than it really is. I was wondering, is it possible to change those sheet names to something like '*' so that i don't have to add a new column and change the formula for all 10 sheets that I have? This formula goes into a worksheet column that contains thousands of lines of info, so Excel tends to slow down quite a bit when I add more columns w/ this formula in it. Can anyone help? Thanks.
It looks worse than it really is. I was wondering, is it possible to change those sheet names to something like '*' so that i don't have to add a new column and change the formula for all 10 sheets that I have? This formula goes into a worksheet column that contains thousands of lines of info, so Excel tends to slow down quite a bit when I add more columns w/ this formula in it. Can anyone help? Thanks.
