help

C

carley465

So I have a spreasheet and on sheet one, Column B are SS# and on Sheet
2 Column B are also SS#, I need to match the SS# and if they match then
I need to fill in column I on sheet one with the date that is in Column
B on sheet 2. Is there an easy way to do this in Excel???

Any help is always appreciated.

Thanks,

C
 
C

carley465

Yes but Vlookup doesn't tell me how if they find it how to fill the date
into Column
B on sheet 2
 
L

L. Howard Kittle

Hi Carley,

As Peo suggests, vlookup will do that. However, you say sheet 2 column B is
ssn's and you want to return to column I on sheet 1 with the DATE from
column B, sheet 2??? First you said there were ssn's and then dates.

If the dates are in column C and the ssn's are in column B of sheet 2, then
put this in column I and fill down on sheet 1.

=VLOOKUP(B1,Sheet2!$B$1:$C$20,2,0)

HTH
Regards,
Howard
 
Top