| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP! having trouble matching info with excel, HELP!
Hi, I'm required to present some info at my work, using two excel files. This
is the task: File 1, has ID numbers in column A, and column B is blank. File 2, has ID numbers in column C and column D has the date the person joined the company File 1 es a select grop of people (about 2500), whereas File 2 is the general database (about 30thou) They're asking me to match the data, in order to end up with the coresponding date they joined the company in column B on File 1 (obtained from column D on file 2), how to do it? taking in account that File 1 is outdated and some people might not be in file 2. I would really appreciate any help you might give me. Gloria |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching up the Same Competitors info | Excel Discussion (Misc queries) | |||
| matching key fields between two workbooks and displaying info when | Excel Worksheet Functions | |||
| Trouble copying info into a spreadsheet | Excel Worksheet Functions | |||
| matching two columns and adding info | Excel Discussion (Misc queries) | |||
| How do I copy info while matching labels? | Excel Worksheet Functions | |||
Threaded Mode
