@mbp
What version of Office are you using now?
Threads with "office-excel-itpro" focus on general issues of Excel clients.
If you use Excel online, it is not supported on Q&A forum currently, I would suggest you post a new question on the following forum.
Microsoft Answers forum for Excel on the web.
If you use Excel clients, such as Excel for Microsoft 365 app, I would like to help you, but could you please provide more informtion?
What does "Excel Populates" mean?
Do you want to use formula to lookup the data of different company? If yes, please share us a simple date sample.
Looking forward to your reply.