Thread: Index, Match
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Index, Match

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