| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: HLOOKUP Text "approximate" match over 2 sheets problem?
Hi, Please help?
I have two sheets, the one is an extract from Payroll about employee details with first, second, third and lastname + initials. The second sheet I have Firstname & Lastname columns and then a column with the job title. I need to match the names and then pull the job decriptions over to the first sheet with the many names and detail and need to match them? Problem is that with the many names you still have surnames with 3 words and to sort and filter that take weeks if sheet 1 has 17000 rows and sheet 2 have 2200 rows. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| How to TURN OFF "wrap text" for all new workbooks/sheets | Excel Discussion (Misc queries) | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| "Wrap Text" problem in Excel 2003 SP2 | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Threaded Mode
