How to match 2 lists and conditionally copy value of one onto the other (pic says all)

**GerritVK** · 10-30-2018, 01:00 AM

Hi,

What I want to do seems obvious, but I can't seem to find or understand the right approach (IF, VLOOKUP, etc.) to fulfil it.
If you would consider the below picture (posting seperatly due to issues): I want to have two lists in Excel; List 1/Column A should be the final list containing company names and Column B should contain their corresponding HQ Towns. Columns C and D are like a working document; a copy paste from an external source such as wikipedia with Company names and their HQ towns. When all data from that source is matched, I would copy paste column B as to keep the value (unconditional, so no longer the result of a function).

The aim is to save myself the time now and in the future of manually matching those lists and copy pasting the variables of interest (such as HQ Town) behind the company names.

What I think the logic should be (but can't translate to Excel language): For each columns C and D, the values next to each other on the same row (e.g. C2 and D2) 'stick' together, while values (words) in column A trigger a copy (D) paste (into B) if they wholly or partially contain the word in column C.

Any help please?
Cheers

**FDibbins** · 10-30-2018, 01:31 AM

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.