autofill with drop down selection

[chulho]

sorry i didn't know how else to title it. tried searching for autofill on the forum but it wasn't what i'm trying to solve.

i have a drop down list (data validation) of names. the names are in column A, and there are 3 name types (position, cell, email) on columns B, C, and D.

i'm trying to have the user select a name from a drop list, then autofill the corresponding name types.

A B C D
(name) (position) (cell) (email)


john president 12 abc
dave accounting 34 def
steve operation 56 ghi


select name: john
position: autofill B
cell: autofill C
email: autofill D


**so the user selects "john", and below, autofill B, autofill C, and autofill D

any help is appreciated!

i've attached a file

[Ace_XL]

In B12
=INDEX($B$3:$B$7,MATCH($B$11,name,0))

In B13
=INDEX($C$3:$C$7,MATCH($B$11,name,0))

In B14
=INDEX($D$3:$D$7,MATCH($B$11,name,0))

[chulho]

thanks!!! works perfectly!!!

simple and elegant!