Assume source data in Sheet1, cols A and B
(first names in col A, last names in col B)

In Sheet2,
First names are entered in A2 down
Put in B2:
=IF(ISNA(MATCH(A2,Sheet1!A:A,0)),"",INDEX(Sheet1!B :B,MATCH(A2,Sheet1!A:A,0)))
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Leecee" wrote:
hi there
im wondering if any can help me out here....my problem is that i have data
that i want to transfer to another worksheet..the data is the first name and
when i type this out on the other worksheet it should come up with the last
name on the next column....e.g tim warren...if i type tim in the first name
column than warren should come up on the last name column.....if i type a
name that is not known it should come up blank...and so on....
any help is wanted...
Thanks