INDEX(AD11&"_MSRP",MATCH(H11,AD11&"_Length"),MATCH (G11,AD11&"_Width"))

INDEX(Data!$D$206:$AB$230,MATCH(H11,Data!$D$205:$D $230),MATCH(G11,Data!$D$204:$AB$204,1))

the above 2 formulas refer to the same table.... and are the same except
that I've allowed for a variable in cell AD11 which changes the defined table
to be referred to. The bottom formula works fine... the top does not as it
returns "#Value". It appears as though when using the defined names, the
quotation marks it adds when referring to the ranges somehow throws off the
result. WHY!!!??? This is used for looking up prices (&"_MSRP") on a cross
reference (width (&"Width")x length (&"_Length")) price list that changes
according to the brand/product selected in a previous cell/drop down list.