I have created multiple defined names or tables in Excel (e.g. Table1,
Table2, etc.)
Each table contains the ingredients and measurements for each recipe.

Using vlookup I have defined the lookup value as the Recipe# and based on
that would like to link the defined table range for the corresponding
Recipe#. For example, if I specify "1" as recipe#1 the vlookup should refer
to the defined name "Table1" and return the ingredient for the default column.

Example (two worksheets contain):
Recipe#1
Table1
A B C
1 can tomato
1 lb beef

Recipe#2
Table2
A B C
2 lbs chicken breasts
1 med onion

The third worksheet (or main wks) contains the grocery list
Lookup Recipe# = 1 (cell A1)
On a separate cell (C2) I put in a formula to concatenate "Table" and "1"
resulting in "Table1" to be used as an array in my vlookup formula:
vlookup(A1,C2,1) which should "1" in column A, row 1; vlookup(A1,C2,2)=can;
vlookup(A1,C2,1)=tomato and so forth, resulting as follows:
A B C
1 can tomato
1 lb beef
Obviously lookup formulas do not accept cell references as defined
names/arrays and it would return "#VALUE!" and this setup does not work for
me.
Would appreciate a solution.