dependants for a drop down list

[Mainer]

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

 

[Pete_UK]

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

 

[Mainer]

thanks a bunch its been a few years

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

 

[Pete_UK]

You're welcome.

Pete

thanks a bunch its been a few years






- Show quoted text -

 

[Mainer]

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]

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

Pete

 

[Mainer]

ok this is how it is...
the top of the worksheet contains a list of id#s,names,date of hire ect in
columns...the columns following them are dates of the month and each day I
input a letter for tardy,absent,excused absent
looks like this
H I J K L M N O P Q R ...
1 id name DOH 1 2 3 4 5 6 7 8 ...31<---days
of the month
2 34097 jane doe 4/04/2003 t t

below this i have created a form and i have a drop down menu using data
validation of the list of id #'s and when an id # is picked it fills in all
the other info(there are alot more columns then shown here) my objective now
is to get the dates of the columns with 't' or 'a' or 'e' down into the form