|
|
#1
05-03-2016, 01:39 AM
|
|||
|
|||
Excel list help please :(
Hi. I have two separate lists, one with company sector(1) and one without (2). I have merged the two lists and want to populate the (2) list with the correct sector(from the corresponding (1) list). The sheet has 140000 entries so copy and paste is simply killing me.
Can anyone help me with a formula to solve this please?? COLUMN A Column B 2Calor Gas Ltd 2Calor Gas Lt[/B]d 1BUSINESS & INDUSTRIAL 1Calor Gas Ltd 2Cambridge Manufacturing Company Ltd 2Cambridge Manufacturing Company Ltd 2Cambridge Manufacturing Company Ltd 2Cambridge Manufacturing Company Ltd 2Cambridge Manufacturing Company Ltd 2Cambridge Manufacturing Company Ltd[/B] 1PHARMACEUTICAL 1Cambridge Manufacturing Company Ltd 
|
| Tags |
| excel2016, formula help, list |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to import list from Excel into drop-down list into word
|
ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
|
Excel Combobox List
|
VBA-User | Excel Programming | 4 | 01-07-2016 02:46 AM |
| Populate Word Drop-down list with Excel column then auto fill form fields with Excel data | Faldinio | Word VBA | 7 | 10-19-2014 06:03 AM |
| How to export contact list to Excel | ksimmonds | Outlook | 2 | 12-07-2011 09:33 PM |
| Searchable list in excel? | leahca | Excel | 7 | 11-24-2011 04:44 AM |
Windows 10 
Office 2016
Threaded Mode