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

Anyone see the problem with this, it isn't working. I am tring to put all
the results (in columns AF:AR) into a cell, based on the input Z3 (The input
will match only one row in AD2:AD361)

Sorry I know I have asked this question tons of different ways but I'm not
able to make it work