populating a cell

P

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!
 
P

Peo Sjoblom

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
 
G

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
 
Top