Hi kasray. Welcome to the forum.
Withe the understanding that Annual*Report is a "typo" and you intend consistency this array entered formula will do that.
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.
In F1 as in the below array enter this formula and fill across until you get blanks.
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
1 |
Annual Report |
*E161 |
|
Search string → |
Annual Report |
*E161 |
*E150 |
*E243, E260, E275, E284 |
*E243 |
2 |
Annual Report |
*E150 |
|
|
|
|
|
|
|
3 |
Annual Report |
*E243, E260, E275, E284 |
|
|
|
|
|
|
|
4 |
Annual Report |
*E243 |
|
|
|
|
|
|
|
Bookmarks