Thread: Index, Match
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default Index, Match

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