Hi Charles

use VLOOKUP in B2 of sheet1

=VLOOKUP(A2,Sheet2!$A$1:$B$100,2,0)

this will give you the information where there is an exact match

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Charles" wrote in message
...
I have two workheets. "WORKSHEET ONE" has a list of LAST names in column
A.
"WORKSHEET TWO" has a list of names last names and first names. Lastnames
are in column A and first names in column B.
What I want to do is look up the last names in worksheet TWO and whenever
there is a match in worksheet ONE move the correstponding first name to
column B of worksheet A.
I have tried all the LOOKUP functions but the problem that I have is that
I
want it only to work when there is an EXACT match!
Can this be done if so how.
Thank you!