Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
index and match
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |