If statement that contains 6+ arguments in excel

[JimJams]

On Excel colum b3 should read between 1 - 6 and colum d needs to take the
data from M1 down to M6

 

[Niek Otten]

=INDEX(M1:M6,B3)