Question - Repost
 

I am reposting my original question (at the bottom) along with the response.

--Original Message--

I don't suppose it would be possible for me to send someone the workbook,
and
have them take care of this for me? I just can't figure this out.

"Gary Keramidas" wrote in message
...
see if this will help

http://www.contextures.on.ca/xlDataVal13.html

--


Gary


"Brandon" wrote in message
...
This is something that I hope is not just in my mind I want to do. What
I'd like to be able to do, is have a drop-down list, and when an item is
selected in that list, it not only puts that item into the cell, but also
a corresponding value into another cell. Here is an example:

Choice Data
x 12345
y 24680
z 13579

In this case, the Choices would be in a list. When I select "x" from the
list, it puts the value "x" into its cell as well as "12345" into an
adjacent cell. If anyone knows what to do, I'd appreciate some help on
this.

Question - Repost
 

--
Regards,
Tom Ogilvy

"Brandon" wrote in message
...
I am reposting my original question (at the bottom) along with the
response.

--Original Message--

I don't suppose it would be possible for me to send someone the workbook,
and
have them take care of this for me? I just can't figure this out.

"Gary Keramidas" wrote in message
...
see if this will help

http://www.contextures.on.ca/xlDataVal13.html

--


Gary


"Brandon" wrote in message
...
This is something that I hope is not just in my mind I want to do.
What
I'd like to be able to do, is have a drop-down list, and when an item
is
selected in that list, it not only puts that item into the cell, but
also
a corresponding value into another cell. Here is an example:

Choice Data
x 12345
y 24680
z 13579

In this case, the Choices would be in a list. When I select "x" from
the
list, it puts the value "x" into its cell as well as "12345" into an
adjacent cell. If anyone knows what to do, I'd appreciate some help on
this.

Question - Repost
 

Brandon,

This seems to be a somewhat simple thing to do. Are you familiar with combo
boxes? If so, use a combo box and have the LinkedCell set to the cell you
want "x" to show up in (ex. - A1). This is done in the combo box
properties. You should have your choice and data options somewhere on the
sheet. Also in the combo box properties, you'll need to set the
ListFillRang to the range of cells that include your choices. If "x", "y",
"z" are in cells C1-C3, then your ListFillRang should be C1:C3. You should
have your data in the column D, or whatever column is to the right of your
choice cells.
Finally, in the corresponding cell that you want the data to show up in, you
can just use a Lookup formula.

=LOOKUP(A1,C1:D3)

HTH,
Paul

"Brandon" wrote in message
...
I am reposting my original question (at the bottom) along with the
response.

--Original Message--

I don't suppose it would be possible for me to send someone the workbook,
and
have them take care of this for me? I just can't figure this out.

"Gary Keramidas" wrote in message
...
see if this will help

http://www.contextures.on.ca/xlDataVal13.html

--


Gary


"Brandon" wrote in message
...
This is something that I hope is not just in my mind I want to do. What
I'd like to be able to do, is have a drop-down list, and when an item is
selected in that list, it not only puts that item into the cell, but
also
a corresponding value into another cell. Here is an example:

Choice Data
x 12345
y 24680
z 13579

In this case, the Choices would be in a list. When I select "x" from
the
list, it puts the value "x" into its cell as well as "12345" into an
adjacent cell. If anyone knows what to do, I'd appreciate some help on
this.