V Lookup & IF

[Reenee]

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

 

[Gary''s Student]

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

 

[Reenee]

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 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]

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,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