I am running Excel 2010. I have a large data set where I have list of information across the top (Row 1) that matches the name of tabs in my workbook. Is there anyway to get the info in Row 1 to popluate the address when I do a vlookup on a different tab. So I could drag a formula across insted of having to do a find an replace. For example:
This is the formula that works
=VLOOKUP(B171,ACK!A3:B3,2,FALSE)
Could we replace the ACK in the vlookup with the cell info so
=VLOOKUP(B171,C1!A3:B3,2,FALSE)
So if I were to drag the formula to the right it would look like
=VLOOKUP(B171,C2!A3:B3,2,FALSE)
I tried the INDIRECT and Address combination but that didn't work:
=VLOOKUP(B171,INDIRECT(ADDRESS(1,3))!A3:B3,2,FALSE)
Bookmarks