Link Tab Name to Cell

G

Guest

Sheet one of my workbook is database that subsequent worksheet draws info from.
The subsequent sheets are all same template with VLOOKUP / INDEX whos return
contingent on entry in one cell in the sheet.

I would like this one cell to equal the TAB or SHEET name.

Is this possible ?

Thanks for your trusted feedback,
Dallas
 
G

Guest

Thank you Kindly Ardus

Ardus Petus said:
=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

HTH
--
AP

SteveT said:
Sheet one of my workbook is database that subsequent worksheet draws info from.
The subsequent sheets are all same template with VLOOKUP / INDEX whos return
contingent on entry in one cell in the sheet.

I would like this one cell to equal the TAB or SHEET name.

Is this possible ?

Thanks for your trusted feedback,
Dallas
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
Copy tab name to a cell or opposite 1
tab name = cell value 7
Autopopulate cell name with tab name 4
Assigning a Worksheet Name to a Cell 4
how can I make a cell content equal the tab name 'sheet1' ? 12
Formula to a sheet name that is text in another cell 1
Excel lookup across entire workbook 1

Top