Sheet Name Changes how do i code for that

S

Sonic

=IF(ISERROR(INDEX([OrderGuideDBS.xls]COG!$A$1:$D$377,MATCH(B4,[OrderGuideDBS.xls]COG!$B$1:$B$377,0),3)),"",INDEX([OrderGuideDBS.xls]COG!$A$1:$D$377,MATCH(B4,[OrderGuideDBS.xls]COG!$B$1:$B$377,0),3))


Ok here is my formula and my problem

OrderGuideDBS.xls is the file name always the same
COG name of the sheet that i forgot was going to change i do not know what
it is going to change to untill i upload the new sheet.

How can i change the about formula to seach the file and bring back the new
sheets name so my code will work

Thank you all for your help
 
Top