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 -