Populating several cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two worksheets, one has a complete list of customers (many columns:
name, phone, address; each row is a different customer, there are well over
2000, each are numbered).

The other worksheet is basically just a mailing label. It has a cell for
the name, cell for the address, cell for the phone, ect. for just ONE
customer.

What I need to do is to be able to type the customer number into a field
into the mailing label sheet and have that one cell populate the name,
address, and phone of the other cells.

I know it's possible, but I can't for the life of me think of the formula.
Any help would be greatly appreciated.
 
There is a function called VLOOKUP() that was designed to do exactly what you
need. The explanation in Excel help is probably good enough for your
purposes. Start there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel template populating from a worksheet 1
Concatenate several rows 4
Use formula to populate cells 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Spreadsheet 3
Splitting Text from single cell in column across multiple Columns 3
Autopopulate cell name with tab name 4
Moving data from one sheet to another- How to? 2

Back
Top