L
lauren_marie
Is it possible to change the formula below so that the worksheet being
referenced is dependent on another cell?
=VLOOKUP($C$4,'Sheet 1'!$H$15:$M$75,2,FALSE)
So if I have
Sheet 1
Sheet 2
Sheet 3 etc in column A, can I reference the vlookup formula to pick up the
worksheet name from column A?
referenced is dependent on another cell?
=VLOOKUP($C$4,'Sheet 1'!$H$15:$M$75,2,FALSE)
So if I have
Sheet 1
Sheet 2
Sheet 3 etc in column A, can I reference the vlookup formula to pick up the
worksheet name from column A?