Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How do I access the current sheet name in formula (to use in INDIRECT)

I want to create a formula that I can use on multiple sheets that will do a vlookup on the table named the same as the current sheet. How do I access the current sheet name in the formula?

The idea is to do the following formula:

=INDIRECT("VLOOKUP(A"&COL()&","&SHEETNAME()&",2,0)")

but as far as I can tell there is no function that returns the name of a sheet.