Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, INDEX and MATCH
I was using the formula below to match 2 indicators listed within an
array. I have another 2 indicators that I CANNOT add to the array. They lie in cells AA2 and AB2. How can I modify the formula below to Index all 4 indicators. =INDEX($A$1:$E$42, MATCH(Y2,$A$1:$A$42,0),MATCH(Z2,$A$1:$E$1,0)) Thanks for the help in advance. LJ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF, INDEX and MATCH
An array is by definition two-dimensional so it is hard to see how you could
point to a cell in the array using an index with more than two entries. Could you give some simple examples? best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "LJ" wrote in message ... I was using the formula below to match 2 indicators listed within an array. I have another 2 indicators that I CANNOT add to the array. They lie in cells AA2 and AB2. How can I modify the formula below to Index all 4 indicators. =INDEX($A$1:$E$42, MATCH(Y2,$A$1:$A$42,0),MATCH(Z2,$A$1:$E$1,0)) Thanks for the help in advance. LJ |
Reply |
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 |