software

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=MID(CELL(quot;filenamequot;),FIND(quot;]quot;,CELL(quot;filenamequot;)) 1,255)

HTH
--
AP

quot;SteveTquot; gt; a écrit dans le message de
...
gt; Sheet one of my workbook is database that subsequent worksheet draws info
from.
gt; The subsequent sheets are all same template with VLOOKUP / INDEX whos
return
gt; contingent on entry in one cell in the sheet.
gt;
gt; I would like this one cell to equal the TAB or SHEET name.
gt;
gt; Is this possible ?
gt;
gt; Thanks for your trusted feedback,
gt; Dallas
gt;
Thank you Kindly Ardus

quot;Ardus Petusquot; wrote:

gt; =MID(CELL(quot;filenamequot;),FIND(quot;]quot;,CELL(quot;filenamequot;)) 1,255)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;SteveTquot; gt; a écrit dans le message de
gt; ...
gt; gt; Sheet one of my workbook is database that subsequent worksheet draws info
gt; from.
gt; gt; The subsequent sheets are all same template with VLOOKUP / INDEX whos
gt; return
gt; gt; contingent on entry in one cell in the sheet.
gt; gt;
gt; gt; I would like this one cell to equal the TAB or SHEET name.
gt; gt;
gt; gt; Is this possible ?
gt; gt;
gt; gt; Thanks for your trusted feedback,
gt; gt; Dallas
gt; gt;
gt;
gt;
gt;