Vlookup Worksheet

[Curtis]

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

 

[ryguy7272]

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

HTH,
Ryan--

 

[Curtis]

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

 

[Glenn]

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)

 

[ryguy7272]

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

HTH,
Ryan--

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

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