Names
Posted by Eugene on October 04, 2001 1:15 PM
Hello
How do i set up so that if a value is true in another worksheet, it will display the name of that worksheet?
Thankyou
Posted by Aladin Akyurek on October 04, 2001 1:36 PM
Eugene,
Either
=IF(Sheet2!A3,"Sheet2","")
or
=IF(Sheet2!A3,LEFT("Sheet2!A3",SEARCH("!","Sheet2!A3")-1),"")
might do what you want.
A3 in Sheet2 is expected to have a logical value. Note that a number value unequal to zero will also give the sheet name as result.
Aladin
========
