Thread: Index and Match
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
zvkmpw zvkmpw is offline
external usenet poster
 
Posts: 153
Default Index and Match

Maybe this would work better:
=INDEX($D$1:$BD$1,MATCH(1,D3:BD3))


Better yet:
=INDEX($D$1:$BD$1,MATCH(2,D3:BD3))