Hello all,
I have a workbook with 72 tabs. On one tab I want to summarize units out of each of the 72 sheets. Can't I reference the tab name in the VLOOKUP formula and paste down?
=Vlookup(A2,&"'"A2&"'!"Range,column)
The tab names are the same as the vlookup cell.
Any ideas????
I have a workbook with 72 tabs. On one tab I want to summarize units out of each of the 72 sheets. Can't I reference the tab name in the VLOOKUP formula and paste down?
=Vlookup(A2,&"'"A2&"'!"Range,column)
The tab names are the same as the vlookup cell.
Any ideas????