Hope you can help.
I want a formulae to look into 2 separate spreadsheets.
The first is a master template list with a list 500 companies names in Column A (A2 - A500)
Distinct title list of types of business in column B1 to column AA1 in alphabetical order. Examples Like below. Going across...