Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V Lookup & IF
Can I do a V Lookup and use a persons social security number as the base, if
so, how? What I am trying to do is pull over the birthdate into the employees tab from the benefits tab, but the problem is that I have over 4K names in the benefits tab and I do not want to use last name because there are multiple people with the same last name. Also, on the side of a person's hire date states true, can I get the date to populate in the 401K worksheet that is on the side of true and the same in the term date for the false field. I have a separate sheet. Please help me |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V Lookup & IF
Say we have data in cols E thru G that looks like:
994-24-6935 James Smith 9/27/1948 164-42-7902 John Johnson 2/17/1941 160-51-4133 Robert Williams 11/30/1986 697-15-8450 Michael Jones 2/17/1985 416-88-7799 William Brown 5/12/1940 491-79-2134 David Davis 4/14/1946 805-78-1171 Richard Miller 1/13/1948 271-13-3137 Charles Wilson 1/27/1996 611-73-7500 Joseph Moore 7/2/1969 768-47-4953 Thomas Taylor 8/28/1993 710-18-2927 Christopher Anderson 7/22/1934 586-97-2716 Daniel Thomas 8/2/1973 107-27-9723 Paul Jackson 3/16/1966 940-67-2563 Mark White 10/25/1977 201-81-6046 Donald Harris 6/3/2003 143-16-9002 George Martin 2/4/2007 164-30-1711 Kenneth Thompson 9/10/1976 In A1 we enter the ssn: 710-18-2927 In B1 we enter: =VLOOKUP(A1,E:G,3,0) to display the correct birthday -- Gary''s Student - gsnu200830 "Reenee" wrote: Can I do a V Lookup and use a persons social security number as the base, if so, how? What I am trying to do is pull over the birthdate into the employees tab from the benefits tab, but the problem is that I have over 4K names in the benefits tab and I do not want to use last name because there are multiple people with the same last name. Also, on the side of a person's hire date states true, can I get the date to populate in the 401K worksheet that is on the side of true and the same in the term date for the false field. I have a separate sheet. Please help me |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V Lookup & IF
In the first sheet data goes from columns A:G with the titles being ssn, last
name, first name, hire&term date, active, full time, and permanent In the second sheet data is in columns A:D and it reads ssn, last name, first name, and birthdate. I am tring to pull in their birthdate to the first sheet in column H how do I do that? "Gary''s Student" wrote: Say we have data in cols E thru G that looks like: 994-24-6935 James Smith 9/27/1948 164-42-7902 John Johnson 2/17/1941 160-51-4133 Robert Williams 11/30/1986 697-15-8450 Michael Jones 2/17/1985 416-88-7799 William Brown 5/12/1940 491-79-2134 David Davis 4/14/1946 805-78-1171 Richard Miller 1/13/1948 271-13-3137 Charles Wilson 1/27/1996 611-73-7500 Joseph Moore 7/2/1969 768-47-4953 Thomas Taylor 8/28/1993 710-18-2927 Christopher Anderson 7/22/1934 586-97-2716 Daniel Thomas 8/2/1973 107-27-9723 Paul Jackson 3/16/1966 940-67-2563 Mark White 10/25/1977 201-81-6046 Donald Harris 6/3/2003 143-16-9002 George Martin 2/4/2007 164-30-1711 Kenneth Thompson 9/10/1976 In A1 we enter the ssn: 710-18-2927 In B1 we enter: =VLOOKUP(A1,E:G,3,0) to display the correct birthday -- Gary''s Student - gsnu200830 "Reenee" wrote: Can I do a V Lookup and use a persons social security number as the base, if so, how? What I am trying to do is pull over the birthdate into the employees tab from the benefits tab, but the problem is that I have over 4K names in the benefits tab and I do not want to use last name because there are multiple people with the same last name. Also, on the side of a person's hire date states true, can I get the date to populate in the 401K worksheet that is on the side of true and the same in the term date for the false field. I have a separate sheet. Please help me |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V Lookup & IF
Same technique, different table format.
Let's assume that the tabname of the second sheet is Sheet2 In H1 of Sheet1, we enter: =VLOOKUP(A1,Sheet2!A:D,4,0) and copy down remember to: 1. format column H of Sheet1 as dates 2. look carefully for errors in column H - they may mean bad or missing data -- Gary''s Student - gsnu200830 "Reenee" wrote: In the first sheet data goes from columns A:G with the titles being ssn, last name, first name, hire&term date, active, full time, and permanent In the second sheet data is in columns A:D and it reads ssn, last name, first name, and birthdate. I am tring to pull in their birthdate to the first sheet in column H how do I do that? "Gary''s Student" wrote: Say we have data in cols E thru G that looks like: 994-24-6935 James Smith 9/27/1948 164-42-7902 John Johnson 2/17/1941 160-51-4133 Robert Williams 11/30/1986 697-15-8450 Michael Jones 2/17/1985 416-88-7799 William Brown 5/12/1940 491-79-2134 David Davis 4/14/1946 805-78-1171 Richard Miller 1/13/1948 271-13-3137 Charles Wilson 1/27/1996 611-73-7500 Joseph Moore 7/2/1969 768-47-4953 Thomas Taylor 8/28/1993 710-18-2927 Christopher Anderson 7/22/1934 586-97-2716 Daniel Thomas 8/2/1973 107-27-9723 Paul Jackson 3/16/1966 940-67-2563 Mark White 10/25/1977 201-81-6046 Donald Harris 6/3/2003 143-16-9002 George Martin 2/4/2007 164-30-1711 Kenneth Thompson 9/10/1976 In A1 we enter the ssn: 710-18-2927 In B1 we enter: =VLOOKUP(A1,E:G,3,0) to display the correct birthday -- Gary''s Student - gsnu200830 "Reenee" wrote: Can I do a V Lookup and use a persons social security number as the base, if so, how? What I am trying to do is pull over the birthdate into the employees tab from the benefits tab, but the problem is that I have over 4K names in the benefits tab and I do not want to use last name because there are multiple people with the same last name. Also, on the side of a person's hire date states true, can I get the date to populate in the 401K worksheet that is on the side of true and the same in the term date for the false field. I have a separate sheet. Please help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |