Enrich Your Contacts Table with Company Trends and Data Insights

Hi, need help. I have 2 tables in a workbook. I have company list table, and contacts table from the company list. The contact table consists of 2 to 3 contacts per company. I have some enrichments in company table, such as company trends, company competitors, recent industry awards etc.. that i'd like to be available in contacts table. I did used lookup, it worked but the results were limited. Some columns doesn't appear in the result. Thanks