VLOOKUP

[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

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

.

..

 

[Ken]

If I am reading your note correctly, in sheet1 case is in
col A, first name is in col B, and last name is in col C.

If so, you would enter =VLOOKUP(A1,'sheet1'!
$A$1:$C$1600,2,0) in col B on sheet2 and enter =VLOOKUP
(A1,'sheet1'!$A$1:$C$1600,3,0) in col C.

The 2 and 3 in these formulas refer to the column in
sheet1 that has the data you want to retrieve.

Hope this helps.