| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
|
#2
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 | |||
Hybrid Mode
