'Excel Script to match common values and copy to the corresponding cell
I've seen similar questions but not this exact thing which I'm stuck on.
Above is a sample of the data i'm working with.
The left column (E) of email addresses is quite long 10,000+ and is in no particular order, with it's corrasponding country (F).
The right column of email addresses (H) is a fraction of the size however it contains many duplicate values.
I need to compare all of the values in E with all of the values in H, if there is a match copy the value in F to the corresponding value in I.
I've looked into Vlookup, VBA scripts and if formulas but I can't get my head around what I need to do here. Any help would be appreciated.
Please and thanks.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|