Formula to make cell reference as name of sheet

[gassiusmax]

Hi Experts,

Is it possible when using a formula that directs to a different sheet name, to get the sheet name from a cells content.

for example

in cell A1 the contents are NAME

My lookup formula reads =IFERROR(VLOOKUP(LEFT(B6,FIND(" ",B6)+1),'NAME'!A:B,2,FALSE),""), in the formula is it possible somehow to replace NAME in the formula with contents of Cell A1 so that as Cell A1's contents change so does the formula

Thanks

Danny

[vlady]

use indirect, something like


=IFERROR(VLOOKUP(LEFT(B6,FIND(" ",B6)+1),(INDIRECT("'" & B$2&"'!$A:$B")),2,FALSE),"")

[gassiusmax]

Sorry for late response, thank you for that it worked a charm