EXCEL 2007

Juan, please check out:-

http://www.pierrefondes.com/

Item number 93.

1. If you copy the formula in cell Sheet1 cell B6 down a few cells (say B7
to B10).

2. Now put 200 or 500 or 600 or 400 in any of cells A 7 to A 10 and the
corresponding cells in column B will be completed.

The, "conversion table" is found in Sheet 2.

If my comments have helped please hit Yes.

Thanks.





"juanpablo" wrote:

Hello,

Im using data validation to enter information from a list of company
addresses.
Can someone associate a name for example for a certain address and copy it
to the next cell, everytime someone selects that specific company address???