Worksheet name in a cell in a different worksheet
Posted by Eric Ellis on February 05, 2002 3:29 PM
Hello,
Is there a way to get a worksheets name in a different workbook? I have this:
=IF(COUNTIF(Broadband!B:B, I4), "y", RIGHT(CELL("filename", B:B), LEN(CELL("filename", B:B)) - FIND("]", CELL("filename", B:B))))
I'm trying make it so it will tell me where it got the information from if it does not find it in the Broadband worksheet. Right now all it does is say the worksheet I am working in because it also has the number it is searching for. Is there a way?
Thanks!
Posted by Eric Ellis on February 05, 2002 9:41 PM
Correction: Is there a way to get a worksheet's name in a different worksheet? (Not workbook)
Additional Info: I have 12 different worksheets. Each of those worksheets look at the 1st worksheet to see if a number has been entered. I want the first worksheet to be able to tell me what worksheet has the actual number (inventory stuff).
I wuold REALLY appreciate any help anyone could give me!
Eric
Posted by Eric Ellis on February 06, 2002 9:01 AM
Well it kinda works. Problem is I have 13 worksheets and I can't nest that many if statements. Unless there is a trick to that too.. I decided it would probably be easier to do something like this:
=IF(COUNTIF(Broadband!B:B, I7), "BB", IF(COUNTIF(LAN_WLAN!B:B, I7), "LAN", IF(COUNTIF('Industry Certifications'!B:B,I7), "I.C.", IF(COUNTIF(Performance!B:B, I7), "Per", IF(COUNTIF(TAD!B:B,I7), "TAD", IF(COUNTIF(CM_Cubicle!B:B,I7), "CM Cube", IF(COUNTIF(Broadband_Cubicle!B:B, I7), "BBC", IF(COUNTIF(TAD_Cubicle!B:B,I7), "TADC")))))))
Ignore the last if because it is nested to far in. Then I can just put in a name. That is fine. BUT, I can't get all the page names in. Any ideas here?
Thanks,
Eric
