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

Sure; the match function would normally tell you how far to advance in the
index. You just need to advance a couple additional rows beyond the category
match... something like
=index(data_column,match(category_label,category_c olumn,0)+1) to get the data
from the first row after the category label (+2 to get data from the second
row, etc).

"M.A.Tyler" wrote:

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

Sounds like all you need to do is add the offset:

=INDEX(B1:B10,MATCH(A15,A1:A10,0)+n)

Where n = offset

Biff

"M.A.Tyler" <Great Lakes State wrote in message
...
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