thanks a bunch its been a few years

"Pete_UK" wrote:

Assume ID# is column C, with first name in column A and last name in
column B etc., and that your drop-down is in M2, then this will
retrieve the first name:

=INDEX(A:A,MATCH(M2,C:C,0))

and this will get the last name:

=INDEX(B:B,MATCH(M2,C:C,0))

and so on for your other fields.

Hope this helps.

Pete

On Sep 22, 12:40 am, Mainer wrote:
i have columns of employee first name,last name, ID#, aniversary date ect.. i
have a seperate area on the same worksheet that i have a form that i have
installed a drop down list of id #s and i would like the form to fill in the
info for the employee for the ID that is picked....seemed like a simple task