using worksheet name

[Deborah J Doyle]

Is there a way to use the name of a worksheet in a formula?

I would like to use the 'if' function and have one of the criteria be the name of the worksheet.

Thanks

[Chip Pearson]

The following formula will return the name of the worksheet on
which it appears.

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1),1)+1,33)

Note that the file must have been saved to disk for the formula
to work. Also, leave the "filename" text intact -- do not
substitute the actual file name


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Deborah J Doyle"
<[email protected]>
wrote in message
news:[email protected]...
>
> Is there a way to use the name of a worksheet in a formula?
>
> I would like to use the 'if' function and have one of the
> criteria be
> the name of the worksheet.
>
> Thanks
>
>
> --
> Deborah J Doyle
> ------------------------------------------------------------------------
> Deborah J Doyle's Profile:
> http://www.excelforum.com/member.php...o&userid=33526
> View this thread:
> http://www.excelforum.com/showthread...hreadid=533220
>

[Deborah J Doyle]

THANKS!! the formula worked perfectly!