Merging sheets

[Dorothy]

I have 2 sheets with similar data that need to be merged.
Example:
Sheet1:

Case First Last

2222 John Miller
3333 Mary Smith
4444 John Jones

Sheet2:
Case

2222
3333
4444

I need sheet1 first & last name column to go to sheet2,
matching up to their case number. Any help would be
appreciated. Thanks...Dorothy

 

[Frank Kabel]

Hi
use VLOOKUP. e.g.
=VLOOKUP(A1,'sheet1'!$A$1:$C$100,2,0)

 

[DOROTHY]

Thanks that worked! Only one problem. I have over 1600
row so I changed the 100 to 1600. Some of the first names
are the same and it's not copying the correct last name.
It's pulling the same last from the first instance of that
first name. Do I have to change the 2 or 0 in the
formula? What do those value stand for? Thanks...Dorothy

 

[Frank Kabel]

Hi
VLOOKUP always gets the first occurence. how should Excel determine
which is the correct one?