I have two distinct lists, one of companies, the others of contacts. I would like to automatically fill the name of the company on my contact list by using the information that is on the company list. How do I merge the information of my two lists? Is it possible to use INDEX and MATCH in this case?
I don't even know how to phrase properly the problem so how could I write a formula that could work...
Thank you for your help!