excel problem...
 

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

excel problem...
 

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

excel problem...
 

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
"Max" wrote:

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

excel problem...
 

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

excel problem...
 

THANK YOU HEAPS...........
LEECEE

"Max" wrote:

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

excel problem...
 

welcome ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Leecee" wrote in message
...
THANK YOU HEAPS...........
LEECEE