Alberto,

If your numbers in column B are consecutive (1, 2, 3... no missing numbers),
you could use the combo box from the forms toolbar. It puts the index
number of the item you selected (2 for the second item, etc.). If they're
not consecutive, you'll need to get the associated number in column B from
the item selected from the first column. Here is a possible solution:

Use the combo box from the forms toolbar. Link it to an extra cell
somewhere (K15 in this example). Then in your cell where you want the
number from column B, use:

=INDEX(B1:B3,K15)

In this case, the extra cell is K15, which you could hide. It should have 2
if the second item was selected in the combo box. The INDEX formula should
get the second item in the column B range.
--
Earl Kiosterud
www.smokeylake.com

"Alberto Vargas" <Alberto wrote in message
...
I am using a combo box to fill in some standard information and I know how
they should appear in the cell, so I can copy and paste to a new cell. But
If
my list has two cell how can I get that the destiby cells appears one of
the
cells info only.

Example

A1 B1
Urban 1
Rural 2
I want to choose Urban from the combo box, but the information to be
stored
in the destiny cell should be 1.
I know how to do it for Urban, that is the destiny will show Urban but I
want to get 1.


Please help

Alberto Vargas