So your source data is in sheet named: Salesperson,
with first names in col A, last names in col B

In sheet: Payroll
First names are assumed entered in A2 down
Put in B2:
=IF(ISNA(MATCH(A2,Salesperson!A:A,0)),"",INDEX(Sal esperson!B:B,MATCH(A2,Salesperson!A:A,0)))
Copy B2 down as far as required. Col B will return the last names (from
Salesperson) corresponding to the first names entered in col A. Unmatched
cases, if any, will return "blank": "".
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Leecee" wrote:
hi there max...
sorry still stuck....

um heres ma data....
First Name (A1) Last Name(b1) Salesperson Sheet
Ben Tamara
Chris Samuelson
LIsa George
Ngaire Hoben
Nihal tim
Tane newton
Zack mann

want to transfer this information to a sheet called payroll.......

Sorry about this.....your help is very much appreciated....
Thanks