Thread: Index, Match
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M.A.Tyler M.A.Tyler is offline
external usenet poster
 
Posts: 100
Default 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