DashboardNovice
Member
In the attached file, in cell D3 of the first tab, I have a VLOOKUP on the value in C3. The table array is on the 2nd tab, columns C and D.
However, to refer to the 2nd tab, I don't want to click on the tab. Instead I have named the 2nd tab as the same name as the value in C3, so that I can reference the 2nd tab by simply referencing C3.
So I have to reference C3 and use the TEXT function to convert the slashes to a period. This has to be surrounded by a single quote at the beginning and the end. Also at the end, an exclamation mark is needed. This will give the sheet name. Then after that, I can reference columns C:D.
But after I hit enter, for some reason, a second TEXT function automatically gets populated.
I also tried the INDIRECT function along with using the & and various combinations of double quotes surrounding a single quote at the beginning and the end of the sheet reference. Nothing is working.
Any suggestions?
However, to refer to the 2nd tab, I don't want to click on the tab. Instead I have named the 2nd tab as the same name as the value in C3, so that I can reference the 2nd tab by simply referencing C3.
So I have to reference C3 and use the TEXT function to convert the slashes to a period. This has to be surrounded by a single quote at the beginning and the end. Also at the end, an exclamation mark is needed. This will give the sheet name. Then after that, I can reference columns C:D.
But after I hit enter, for some reason, a second TEXT function automatically gets populated.
I also tried the INDIRECT function along with using the & and various combinations of double quotes surrounding a single quote at the beginning and the end of the sheet reference. Nothing is working.
Any suggestions?