hi, i have the following formula.... =LEFT('5'!$D16,1) which would look at the tab named 5 and take a letter from the word in D16.
works fine.
now, what if in my current sheet, i have the tab name (ie 5) in a cell. how can i make this dynamic?
if 5 is shown in A1, can i do: =LEFT('"A1"'!$D16,1)
works fine.
now, what if in my current sheet, i have the tab name (ie 5) in a cell. how can i make this dynamic?
if 5 is shown in A1, can i do: =LEFT('"A1"'!$D16,1)