Guys I got this formula
=INDEX(TabNames,MATCH(TRUE,COUNTIF(INDIRECT("'"&TabNames&"'!k14"),S3)>0,0))
it is suppose to find the appropriate sheet name and I keep getting #VALUE!
For example
S3 shows a value that is located on one of 50 sheets?
this is suppose to tell me the sheet name?
Any ideas?
Bookmarks