Drop Down Menu changes changes multiple cell values

DROP DOWN QUESTION.xlsx If you take a look at the attached file, is there a way I can get A1 to be a drop down menu that holds 1, 2, 3, 4 in it? When 1 is picked cells (A2:A4) show the values of the 3 cells directly under the 1 column (i.e. .3, .2, .8 in cells A2, A3 and A4 respectively). The same goes for when 2, 3 or 4 or picked from the drop down.

Originally Posted by dompoma

If you take a look at the attached file...

I don't see an attached file?

OK, try this...

Setup the drop down list

Select cell A2
Goto the Data tab>Data Tools group>Data Validation
Allow: List
Source: =$C$1:$F$1
OK out

Enter this formula in A2 and copy down to A4:

=IFERROR(INDEX(C$2:F$4,ROWS(A$2:A2),MATCH(A$1,C$1:F$1,0)),"")