I have lots of fixed name worksheets within a workbook. I want to set it up so that i can 'vlookup' an array within a worksheet, based on a formula. That is i would like to use the worksheet address in the formula as a variable (ie, look up 'workbookA' this time, then [based on calculations] look up 'worksheetX'.
=VLOOKUP(G17,'worksheet'!$A$9:$I$400,6,FALSE)
I have tried several things but i'm unable to set 'worksheet' in the above equation as a variable.
