I Have a cell (lets say its A1) that specifies (from a drop-down list) a Sheet Name (AA BB CC DD etc) I want to pass that sheet name to a VLOOKUP Formula which would (if life were simple) be SOMETHING LIKE =VLOOKUP(B5,A1&!D1:E22,2,False) Where B5 is the cell containing the Lookup_value, A1 is the cell containing the sheet name, and D1:E22 is the Table array (it is the same on each sheet!).
I have been told the INDIRECT formula should work, Or even TABLES? but I am yet to find a way to get a successful result.
Anyone Know? Thanks