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

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

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

You're welcome.

Pete

On Sep 22, 1:47*am, Mainer wrote:
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- Hide quoted text -

- Show quoted text -

ok...on the same note i need to check for a letter in the same row say a
range lets say H12-AL12....12 being the row it found in the first example you
gave...i now need to get the info from the top of the chart which is in row 7
....little lost ..any help is welcome and thanks in advance :)

"Pete_UK" wrote:

You're welcome.

Pete

On Sep 22, 1:47 am, Mainer wrote:
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- Hide quoted text -

- Show quoted text -

I don't quite understand. Can you elaborate, and ideally post an
example of what you are trying to do.

Pete

On Sep 22, 11:56*pm, Mainer wrote:
ok...on the same note i need to check for a letter in the same row say a
range lets say H12-AL12....12 being the row it found in the first example you
gave...i now need to get the info from the top of the chart which is in row 7
...little lost ..any help is welcome and thanks in advance :)



"Pete_UK" wrote:
You're welcome.

Pete

On Sep 22, 1:47 am, Mainer wrote:
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- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -