| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel problem...
welcome ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Leecee" wrote in message ... THANK YOU HEAPS........... LEECEE |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| excel office V excel viewer, slight problem | New Users to Excel | |||
| EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Linear Mode
