Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dependants for a drop down list
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dependants for a drop down list
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dependants for a drop down list
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
dependants for a drop down list
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 - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
dependants for a drop down list
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 - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
dependants for a drop down list
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 - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
dependants for a drop down list
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 "Pete_UK" wrote: 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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Dependants | Excel Discussion (Misc queries) | |||
Trace dependants/precedents from another worksheet | Excel Discussion (Misc queries) | |||
Trace Dependants Not Working... | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Trace Dependants | Excel Discussion (Misc queries) |