Want a number of cells to be auto completed based on entry in one.

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

Guest

In Excel, I want a number of columns to be filled in automatically based on
putting an entry in one cell. I.E. If I put a customer number in one column,
I want the next column to be filled in with the cust. name, the following
column filled in with the cust phone number, and so on. I am using excel
2003.
 
Matt

You will need a VLOOKUP function, so if you place the data Cust#, Name,
address etc on sheet2 then on sheet1 you will enter a formula similar to
this (In B1 where you are entering the cust # in A1 and to return the data
in the second column in the list on Sheet2)

=VLOOKUP(A1,Sheet2!$A$1:$E$100,2,FALSE)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You must log in or register to reply here.

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

Reference the same cell based on tab name 1
Reverse Lookup question 8
How to fill out a table (a row) with data from another worksheet 4
How can I automatically color a cell based upon a condition being 4
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
large database with multiple rows 2
vlookup - HELP 2
Auto Fill Down Macro 5

Back
Top