View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BrettM
 
Posts: n/a
Default INDEX then MATCH

=INDEX(all!A1:K1338,MATCH("300",all!A1:A1338,0),11 ) cannot locate "300" or
any other "numbers" I may enter. This works fine if I add a letter (i.e.
"300E") yet help screens show "numbers" should work ok? Can anyone shed any
light here or offer a better formula? Many thanks in advance.