How to do an Indirect VLOOKUP using Names Ranges within another Sheet?

[aslif]

Hi,

Any help on this would be very much appreciated.

Here is the Formula I have in one worksheet(all within one workbook): INDIRECT(SheetName&VLOOKUP(SheetName,ColLutGrid,COLUMN(),0)&RowNumber)

SheetName, ColLutGrid, and RowNumber are named ranges.

These pull data from two other sheets that get updated weekly.

I am trying to get the data in another Sheet to dynamically update from the same data on a weekly basis.

Thank You

 

[konew1]

what is wrong with your formula? what do you get returned?

Indirect(Sheetname will return an error if the named range is larger than a single cell.
I expect it is larger than a single cell because of the vlookup component