Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index, Match
Is it possible for an "Index Match" result to return data stored in the cell
below the index, match intersection? My sheet has catagories in column B, each catagory has six sub catagories. I could just use the sub catagories in the index, match formula, but all the sub catagories have the same titles. Thought it might be easier to use the catagory title in the index, match and count down for the desired sub catagory. Thanks, M.A.Tyler |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
index match | 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 | |||
Index & Match | Excel Worksheet Functions |