Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Want a number of cells to be auto completed based on entry in one.
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. |
#2
|
|||
|
|||
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 HIS "matt ashley" <matt wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells show wrong number | Links and Linking in Excel | |||
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
Can auto number (or OFFSET) include letters? | Excel Worksheet Functions | |||
Count number of shaded cells | Excel Discussion (Misc queries) |