Good morning fellows,
I am searching now already quite a bit on the web and in this forum but was not able to find a solution.
I am trying to assign reference numbers to company names (text). The problem is that each company has multiple numbers assigned. Now, I would like to assign to each company all the reference numbers out there in my excel file. I found now the vlookup-formula here in the forum, but that one only chooses one of the reference numbers. I need all of them.
I attached my file.
Column A: Company names
Column B/C/D: Place to assign numbers
Column E+F: Company names plus reference numbers.
Bookmarks