View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default If statement that contains 6+ arguments in excel

=INDEX(M1:M6,B3)

--
Kind regards,

Niek Otten

"JimJams" wrote in message
...
On Excel colum b3 should read between 1 - 6 and colum d needs to take the
data from M1 down to M6