Drop Down Box Help

  • Thread starter Thread starter smckay
  • Start date Start date
S

smckay

Hi I am new to using Excel more interactively. I am able to create
drop down box so a user can choose a day of the week for example.

But I want to be able to populate other cells in the column dependin
on the choice from the drop down list.

e.g. choose Tuesday from a list of days of the week in A2 and have B2
C2 etc filled with related data.

Is this at all possible?

Thank you in advance
 
This is quite possible. If you have only a limited number of choices, you
can use IF statements in the cells to populate. If you want more choices,
use a vlookup in the cells to populate, using the drop down cell as the
lookup value.

I made a very simple example spreadsheet, but I don't know how to insert it
into this message. Email me if you'd like, and I'll send it to you.
 
the second I can PM you (must be too few posts) I would love some help.

I have tried to use some if statements;

if "selection a"
then "situation a"
else
if.............

cheers manxma
 
You need VLOOKUP. Check it out in help.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Bob said:
You need VLOOKUP. Check it out in help.

Hi Bob I had a quick read of VLOOKUP. So depending on the Selection o
the drop down the VLOOKUP formula will populate the other cells in th
row?

sorry I am trying to get my head around i
 
Yes, you use the DV cell as the lookup value, in each case, and referent
into a table of values using a different column offset for each value. make
sure you use the ,False) at the end.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Ok this is driving me crazy I must be doing something obvious wrong,
here is what I have

Column A
Drop Down Box with options
RAM
CPU
HARD DISK


Column B
If Ram is selected a description of the RAM
If CPU is selected " " " " "
currently this will not work! :(
 
send me an email to (e-mail address removed) and I'll send you that short
spreadsheet illustrating the vlookup solution.
 
thanks to everyone who helped, I now understand vlookup and have
spreadsheet that does as I want it to! :D

cheers al
 
Back
Top