MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

========