V Lookup & IF Function

[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.

 

[Kassie]

The answer to all your questions is yes. However, it all depends on how your
database is set up? Is the social security number the first field (on the
left) with the rest to the right there-of? Alternatively, can you move the
social security column to A column? Then you need to sort on social security
field, to effectively use VLOOKUP.

After that, the formula is quite straightforward. It all depends on how
many columns to the right the various fields are that you want to populate
from. You could call your list in the benefits tab Database by declaring it
as a range name. Your employee tab will then also have the soc sec nr as the
first field, and in every column to the right where you want to import info,
you would use a formula =VLOOKUP(A1,Database,2(or how many columns to the
right),0). To combine with the IF formula, although I would think that that
could be rather ambiguous, you would merely use the one VLOOKUP on the Then
side, and the other VLOOKUP on the ELSE side.