Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
matt ashley
 
Posts: n/a
Default 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   Report Post  
Nick Hodge
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked cells show wrong number Guy Links and Linking in Excel 4 April 21st 23 08:07 PM
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. dencrowell Excel Discussion (Misc queries) 1 April 14th 05 04:11 AM
Auto populate cells based on 2 cells division. Chance224 Excel Discussion (Misc queries) 0 April 4th 05 09:35 PM
Can auto number (or OFFSET) include letters? Colleen B Excel Worksheet Functions 3 February 21st 05 10:17 PM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"