![]() |
#1
|
|||
|
|||
![]()
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 | Thread Starter | Forum | Replies | Last Post |
![]() |
ahw | Word VBA | 43 | 02-28-2020 08:11 PM |
![]() |
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 |