Vlookup with Indirect

[Delta Star]

Something that I'm struggling with is probably very simple, but I would appreciate some help.

I'm trying to use a table name that is listed in a cell. I'm sure I need to use the indirect function but cannot get it to work.

This is what I have got so far: =VLOOKUP(A1,INDIRECT(Calcs!B11),4,FALSE)

Can anyone assist?

 

[VoG]

That works for me with the name of a named range in B11.

 

[Delta Star]

Just solved it. The table named ranges are dynamic and when I changed them to static it solved the problem.