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

Vlookup will do that for you. Look at this:
http://www.contextures.com/xlFunctions02.html

HTH,
Ryan--

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


"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

Thanks

I am pretty comfortable using vlookup except in this case I cannot see where
it shows me to vlookup a tab in a workbook

"ryguy7272" wrote:

Vlookup will do that for you. Look at this:
http://www.contextures.com/xlFunctions02.html

HTH,
Ryan--

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


"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

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)

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)
.