data validation - dependant combo box

  • Thread starter Thread starter kusazero
  • Start date Start date
K

kusazero

my excel skills is no more than having a certain cell multiplyin
another cell.

scenerio:

i have 2 cells, with drop down box. box2 is dependant to selections o
box1.

after i chose the item in box2, i would like, let say, cell A3, A4, A
to display certain data about the item i selected in box2.

lets say, i selected "Peter" on box2, i would like A3 to display hi
"sex", A4 being "age", A5 is "height".

thank
 
thanks, thats how i learnt about data validation, but what i want is t
have a few cells display the info i wanted upon my selection on the 2n
box, ideas or pointers
 
Hi
some ideas:
1. Based on the value of your combo box (lets say in A2) you can use
IF:
=IF(A2="choice 1","choice 1 was chosen","something else")
2. You can use VLOOKUP to get some other values using the drop down
result as search criteria:
=VLOOKUP(A2,your_lookup_table,row_index,False)

HTH
Frank
 
Back
Top