Vlookup formula to reference a named table based determined by a separate cell value

[H3MSY]

Hi, apologies if the title is misleading but not sure how to word it

I have a vlookup formula that uses a named range to pull its data from

=VLOOKUP(A20,Table1,5,)

I have 10 tables to pull data from so rather than the formula saying Table1 i would like the formula to refer out to a cell (A1 for example) that has a drop down that says table1, table2, table3 etc etc....

Ive googled and looked through this forum and thought indirect may have been the answer but i cant get it working.

Thanks for any help/pointers

 

[Fluff]

How about

=VLOOKUP(A20,Indirect(A1),5,)

 

[H3MSY]

How about

=VLOOKUP(A20,Indirect(A1),5,)

Brilliant, works a treat.
Many thanks for taking the time to reply.

 

[Fluff]

You're welcome & thanks for the feedback.