View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
 
Posts: 342
Default =INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)

Index will not pull all of the data related to one row in a table, it will
only pull one value. For Index to work you need one value to be selected
from the left column and one value from the top row.

Have you considered filtering you data to get what you want?

Tom