data validation - dependant combo box

[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

 

[Frank Kabel]

Hi

have a look at
http://www.contextures.com/xlDataVal02.html
for dependent data validation lists

HTH
Frank

 

[kusazero]

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

 

[Frank Kabel]

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