Cell Reference for table_array in Vlookup

[Amyers]

Is there any way a cell reference can be used as the table_array value in the Vlookup function?

For example, I would like to change the manufacturer from Widget to Quirk and Excel to automatically look up the correct cost based on the size.

Manufacturer...........Size..........Cost
Widget.....................2..............4



......Widget.............................Quirk
..Size.....Cost......................Size....Cost
...2..........4..........................2........3
...4..........8..........................4........7

So instead of the formula under Cost being Vlookup(B2,Widget,2) the formula would bee Vlookup(B2,A2,2).

 

[Amyers]

I have actually figured out how to do this. It would be Vlookup(B2,INDIRECT(A2),2).