LOOKING UP A TABLE/SHEET AND MATCH FOR A STRING OR NUMBER
 

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!

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!

Try this:

With datalist in A2:B20 on Sheet2
And A2:A20 on Sheet1,
Enter this in B2 of Sheet1, and drag down to copy:

=VLOOKUP(A2,Sheet2!$A$2:$B$20,2,0)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"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!