drop down menu ( list)

[Guest]

I have made a drop down list to select different (text) names. Is there a way
to make each name correspond to a different number and place that number in a
different cell

For ex.

Cell # A1 Cell # A4
Chad 2
Nick 12
Jason 118

 

[Peo Sjoblom]

Use a lookup table


=IF(A1="","",VLOOKUP(A1,$K$1:$L$20,2,0))

where you would create a 2 column table with the list you are using in the
left column and the
numbers in the right column

In my example I used table in

$K$1:$L$20

you obviously need to have this in another cell as opposed to in the cell
with the dropdown

 

[Guest]

Hi,

For more information, please refer to this URL:
http://www.contextures.com/xlDataVal02.html.

Note: At the end of this page there are for more information corresponding
to list.

Challa prabhu