Drop down box

[ineedadedt]

OK Another q.. I have a drop down box with the info NJ 01, NJ 02, - NJ 06. I want to set up another cell with the corresponding manager. So if someone selects NJ 01 the sheet would auto fill with John Smith in a different box.

Any suggestions on this?

Thanks again

 

[luckycharm]

Try searching for threads on this subject.
There were few just last few days.
I specifically remeber awesome contribs (specially Aladin's).
Or wait.

 

[Brian from Maui]

OK Another q.. I have a drop down box with the info NJ 01, NJ 02, - NJ 06. I want to set up another cell with the corresponding manager. So if someone selects NJ 01 the sheet would auto fill with John Smith in a different box.

Any suggestions on this?

Thanks again

Have a look at VLOOKUP. Construct a two column table. First column with NJ 01 etc and in the adjacent cell the name associated with NJ 01. Then use

=VLOOKUP(B1,$A$1:$B$6,2,0)

Where B1 is the cell to auto fill John Smith

 

[Chard9401]

you will need all you data stored in a table somewhere on the spreadsheet. Then create a VLOOKUP so that when a number is selected from your drop down list it will enter the data automatically! i.e John Smith

Like this

I.D No. Name Age
ABC 123 John Smith 25
ABB 456 David Beckham 28

Then highlight the table and name the selected area. Once you have done this you can create the following VLOOKUP

=VLOOKUP(A1,selectedareaname,2,FALSE)

 

[ineedadedt]

Will it matter if the one column is at the top and the other one is at the bottom. The cells are going to be B9 and C46.?

Thanks...much appreciated.

 

[Brian from Maui]

Will it matter if the one column is at the top and the other one is at the bottom. The cells are going to be B9 and C46.?

Thanks...much appreciated.

What's in B9 and C46? And what do you mean by one column at the top andother is at the bottom/

 

[Chard9401]

what do you mean by the 1 column?

 

[ineedadedt]

I think I should have said row not column..I have to watch my wording..sorry..

So my cells look like this

B9 has the drop down box. Choose what region
C46 is the blank where I would like the Regional Manager to fill in.

 

[Chard9401]

yes thats fine it can work like that! are you clear on how to set it up? If not i can explain it with abit more detail

 

[Brian from Maui]

I think I should have said row not column..I have to watch my wording..sorry..

So my cells look like this

B9 has the drop down box. Choose what region
C46 is the blank where I would like the Regional Manager to fill in.

In the example I provided, change B1 to C46