Index, Match

[Guest]

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

 

[Guest]

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_column,0)+1) to get the data
from the first row after the category label (+2 to get data from the second
row, etc).

 

[T. Valko]

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

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

Where n = offset

Biff