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

irenesboy

Board Regular
Joined
May 28, 2004
Messages
90
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
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,719
Messages
5,597,736
Members
414,170
Latest member
Mdm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top