Vlookup Worksheet

  • Thread starter Thread starter Curtis
  • Start date Start date
C

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
 
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
 
Curtis said:
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
Click to expand...


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_Function_Returns_Sheet_Name,_Workbook_Name_and_Path/180.html

HTH,
Ryan--

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


Glenn said:
Curtis said:
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
Click to expand...


Worksheet name:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99)
.
Click to expand...
 
Back
Top