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!