Yes, lookup Vlookup in Help.

If you still need help, post back with more specific information.

--
Regards,
Fred


"samuel" wrote in message
...
i have 2 different worksheets.

Sheet 1:
A B C D
LastName FirstName FirstName LastName

Sheet 2:
A B
UserID FirstName Middle LastName

I want to search Sheet2 Column B for containing Sheet1 column D

If Sheet1 D is found in Sheet2 B then return Sheet2 A into Sheet1 A

Is there a way to do this?