Cell value as table array in VLOOKUP

[hrushi]

I have a cell suppose B1 = "APPL"
I have a Table named "APPL_PRICE" which has Date column & Price Column.
I want to VLOOKUP a specific Date( in A1) from the table using the reference of B1
Such as =VLOOKUP($A$1,APPL_PRICE[Date],2,FALSE)
But instead i need to use reference of B1
=VLOOKUP($A$1,(B1&"_PRICE")[Date],2,FALSE) as i have 50 other tables to do the same work. Instead of selecting the table array present indifferent worksheets,I have named them and want to use them

 

[Fluff]

Hi & welcome to MrExcel.
How about

=VLOOKUP($A$1,INDIRECT(B1&"_PRICE"),2,FALSE)

 

[hrushi]

Hi & welcome to MrExcel.
How about

=VLOOKUP($A$1,INDIRECT(B1&"_PRICE"),2,FALSE)

And suppose i had to vlookup from the 3rd row in such table. My vlookup value is not in the 1st column then? Like using APPL_PRICE[Volume] being vlookup in the column of Volume in the table
Using Indirect for this particular instance doesn't work

 

[Fluff]

And suppose i had to vlookup from the 3rd row in such table.

It doesn't matter what row it's on, vlookup looks down the whole column.

You posted a very general question with a formula that would not work, so I gave you a general solution.
Without accurate information I cannot do any more.