populating a cell
 

How can I populate a cell with data from other cells? ie,
if I put a customer number in a cell I would like it to
retreive that customers' address, phone, etc,.. from data
I've placed about that customer elsewhere? Any help is
greatly appreciated!

Hi
use VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

Pat S wrote:
How can I populate a cell with data from other cells? ie,
if I put a customer number in a cell I would like it to
retreive that customers' address, phone, etc,.. from data
I've placed about that customer elsewhere? Any help is
greatly appreciated!

Unless you use VBA you would need other cells as well and the cell with the
customer number as lookup value

=VLOOKUP(A1,Sheet2!A2:D100,2,0)

in let's say B2, in C2

=VLOOKUP(A1,Sheet2!A2:D100,3,0)

and so on depending on how many different columns you need to extract

Regards,

Peo Sjoblom

"Pat S" wrote:

How can I populate a cell with data from other cells? ie,
if I put a customer number in a cell I would like it to
retreive that customers' address, phone, etc,.. from data
I've placed about that customer elsewhere? Any help is
greatly appreciated!

Pat

You cannot return values to the cell you enter the number in.

Suggest you use a VLOOKUP table and formulas to return your data to adjacent
cells.

Good instructions and examples at Debra Dalgleish's site.

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

OR just use Excel's Help on VLOOKUP Function.

OR load the LOOKUP Wizard add-in under ToolsAdd-ins

Gord Dibben Excel MVP

On Wed, 22 Dec 2004 13:47:27 -0800, "Pat S"
wrote:

How can I populate a cell with data from other cells? ie,
if I put a customer number in a cell I would like it to
retreive that customers' address, phone, etc,.. from data
I've placed about that customer elsewhere? Any help is
greatly appreciated!

Frank Kabel, Peo Sjoblom & Gord Dibben....thanks so much.
It was perfect!
Pat