How to create a list that shows one value and gives another

[Nuno]

The problem is simple, i have to create a list that shows one value and gives
another correspondind at the same line but another column.
Does any one have any ideas if is it possible aon how to make it?
Thanks

 

[Pete_UK]

Please give further details of what you are trying to achieve. It
sounds like VLOOKUP is the function which you can use to do this.

Pete

 

[Nuno]

Well i'm trying to make a list where in the cell you select one name,in the
list, and it gives you one code in the same cell,is this making any sense?.
How ever if i use any funcion that shows me that have a circular reference.
That VLOOKUP doesn't work for the same cell.it has to read and write in the
same cell.

 

[Max]

.. trying to make a list where in the cell you select one name, in the

list, and it gives you one code in the same cell

Option 1: From a post by Debra Dalgleish ..
You can do this with data validation and programming.
There's a sample file here:
http://www.contextures.com/excelfiles.html
Under Data Validation, look for DV0005 - Data Validation "Columns"

Option 2: Use a combo box from the control toolbox toolbar
Try this sample from my archives which illustrates:
http://savefile.com/files/221672
Combo box from control toolbox toolbar_Example2.xls
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,000 Files:354 Subscribers:53
xdemechanik
---