populating a cell

[Pat S]

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]

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

 

[Guest]

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

=VLOOKUP(A1,Sheet2!A2100,2,0)

in let's say B2, in C2

=VLOOKUP(A1,Sheet2!A2100,3,0)

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

Regards,

Peo Sjoblom

 

[Gord Dibben]

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 Tools>Add-ins

Gord Dibben Excel MVP

 

[Guest]

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