If you wish to return the column A data that "matches" the column B data array enter this in cell C1 as in the attached and fill down.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.If you wish to do it the other way around as in the attached array enter this in G1 and fill down.
|
A |
B |
C |
D |
E |
F |
G |
1 |
ABC International |
Walmart Inc. |
Walmart |
|
ABC International |
Walmart Inc. |
ABC Intl |
2 |
KFC |
Swiss Intl Airlines |
Swiss Air |
|
KFC |
Swiss Intl Airlines |
KFC International |
3 |
Walmart |
Pizza Hut Inc |
Pizza Hut |
|
Walmart |
Pizza Hut Inc |
Walmart Inc. |
4 |
Mc Donalds |
Mc D |
Mc Donalds |
|
Mc Donalds |
Mc D |
Mc D |
5 |
Swiss Air |
KFC International |
KFC |
|
Swiss Air |
KFC International |
Swiss Intl Airlines |
6 |
Pizza Hut |
Adobe International |
Adobe Intl |
|
Pizza Hut |
Adobe International |
Pizza Hut Inc |
7 |
Adobe Intl |
ABC Intl |
ABC International |
|
Adobe Intl |
ABC Intl |
Adobe International |
Bookmarks