data fill problem

  • Thread starter Thread starter news.carnet.hr
  • Start date Start date
N

news.carnet.hr

Hello to everyone!
I would like to know if there is the way to do the following:
- to achieve dropdown list in cell (names of the firms, for example), and
when user select one of the firm, other cells get filled
with data, like adress of the firm, number of account etc.
During past week I spent a lot of time by my computer to solve this problem,
but without any results.

If anyone can help I would be thankful!

Andrew.
 
On one sheet
A B C
1 Comp Add Acct
2 C1 A1 #1
3 C2 A2 #2
4 C3 A3 #3
5 C4 A4 #4
6 C5 A5 #5

In cell A10 use "Data" -> "Validation" and set it up as a list with the
source being the company names (ie A2:A6)
In cell B10 to retrieve the address
=VLOOKUP(A10,A2:C6,2,FALSE)
In cell C10 to retrieve the Account #
=VLOOKUP(A10,A2:C6,3,FALSE)

Dan E
 
Hi Boris,

Just a slight correction - You can use a data validation
source list from a different worksheet if you give the
list a defined name, eg: source =mylist.

Sorry I can't help with your pivot table.

Biff
 
Hi Boris,

Just a slight correction - You can have a source list on
another worksheet if you give it a defined name.

Sorry I can't help with the PT.

Biff
 
biff, am very curious to know how. This would be useful
for me, so if you can tell me how to reference the name
in the "Source" area, would be appreciative.

boris
 
Suppose your source list is in Sheet2!A1:A10. Select this area and give it a
name (let's say range1) in the normal way. (In case you don't know, click in
the name box which is to the left of the formula bar and type in the name.)

Now go to the other sheet and select the area to which you want to apply
validation.
Data > Validation
Change the Allow box to List and in the Source box type
=range1
OK
 
Back
Top