ei does anyone knows how to do this..here's the exmaple

WORKSHEET1

A B C
D
1 SSN Last Name First Name Rate
2 525-23-2222 SMITHS ALEX 32
3 424-22-3344 LANE JAMIE 20


WORKSHEET2

A B C D
E
1 Last Name First Name SSN Rate Hour
2


NOTE: what i want to happen is that once i enter the SSN data i
worksheet2 the Last Name, First Name and the Rate will also appear i
worksheet2 its like an auto entry....i only want to enter the SSN s
that i wont keep typing of the names and the other data.. is there
code or formula for this? please help me so....tnx a lot.

--
Message posted from http://www.ExcelForum.com

for last name

=if($c2<"",Vlookup($C2,Worksheet1!$A$2:$D$3,2,Fal se),"")

for first name

=if($c2<"",Vlookup($C2,Worksheet1!$A$2:$D$3,3,Fal se),"")

for rate
=if($c2<"",Vlookup($C2,Worksheet1!$A$2:$D$3,4,Fal se),"")

--
Regards,
Tom Ogilvy


"gelo_d " wrote in message
...
ei does anyone knows how to do this..here's the exmaple

WORKSHEET1

A B C
D
1 SSN Last Name First Name Rate
2 525-23-2222 SMITHS ALEX 32
3 424-22-3344 LANE JAMIE 20


WORKSHEET2

A B C D
E
1 Last Name First Name SSN Rate Hour
2


NOTE: what i want to happen is that once i enter the SSN data in
worksheet2 the Last Name, First Name and the Rate will also appear in
worksheet2 its like an auto entry....i only want to enter the SSN so
that i wont keep typing of the names and the other data.. is there a
code or formula for this? please help me so....tnx a lot..


---
Message posted from http://www.ExcelForum.com/