Can this be done? or Best way to handel this setup

[irenesboy]

I Have data in columns
AD AE AF AG (will be used for final scores)
1001 DEN -4
1002 STL 4
1003 DENO 46
1004 DENU 46
1005 BUF 10
1006 NE P -10
1007 NEPU 41
1008 NEPO 41
I want to set it up so that I can click on a cell in column C and it will open a drop down list and it will insert the above data in column C, D, and E.
If I click on 1001 it will insert 1001 in C, DEN inD, and -4 in E.
If this cant be done what is the best way to do what I am trying to do.
Thanks for any help.
irenesboy

 

[NBVC]

You can do this with Data Validation and Vlookup


While in a cell of column C, say C2, go to Data|Validation and select List from the Allow drop down.

In the source box enter the range that your select data is in, e.g. AD1:AD100

Click ok.

Now in D2, enter =Vlookup(C2,$AD$2:$AG$100 ,2,0) and in E2 enter =Vlookup(C2,$AD$2:$AG$100 ,3,0)

adjust all ranges to suit.

data validation and formulas can be copied to cells below.

 

[irenesboy]

Thanks very much for the help.
irenesboy

 

[irenesboy]

Thanks very much for the help.
irenesboy