|
|
#2
05-03-2016, 02:52 AM
|
|||
|
|||
To be clear - as an example - Calor Gas
(sector)Row 1 column A (Empty) (Company) Row 1 column B "Calor gas" (from list 2) (sector)Row 2 column A (Empty) (Company) Row 2 column B "Calor gas" (from list 2) (sector)Row 3 Column A ("Business & Industrial") (Company) Row 3 column B "Calor gas" (from list 1) I would like to create a formula that looks up Company(Column B) List 1 and corresponding sector(in column A)- then identifies matching company from list 2 (in the same column) and populates the empty cell in column A: with the correct sector from list 1 COLUMN A. 
|
| Tags |
| excel2016, formula help, list |
|
|
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