Whoops, misread your post. Look at this:
http://www.exceltip.com/st/Cell_Func..._Path/180.html

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Glenn" wrote:

Curtis wrote:
I want to lookup the name of the worksheet and place the corresponding
department name in a cell of the worksheet

for example the worksheet name will be 1500 which represents department
"Aviation"

I have a department list sheet that would contain the group (1500 and the
respective department

Thanks


Worksheet name:

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