这是我1秒钟的时间访问这个论坛寻求帮助，因此请提前原谅任何新秀错误。
上下文：我正在创建一个勘探联系人数据库，以实现定制软件开发的B2B销售策略。公司。我开始手动构建此数据库作为MVP，但是很快就会发现机会在勘探平台（例如Apollo）的帮助下优化IT收集数据。
我的挑战：我想从1st 7列列将特定数据从电子表格文件A（1st image，Yellow Fields）转移到电子表格文件B（第二映像），该查询基于查询，该查询使用公司名称在文件2中用作文件2查询标准并从7个黄色列中返回数据
file a
file b
重要说明：
a）从文件b“公司”查询时，每个公司可能会有1个以上的联系。在这种情况下，查询应么）i）返回1个名称，ii）返回错误消息或iii）在文件b上创建一个额外的字段，以在另一个联系人（更复杂）
b）上插入信息，b）从文件b'Company进行查询时'文件B中的列行可能已经填充了其他联系人的先前信息。在这种情况下，查询应i）返回错误消息或ii）在文件B处创建一个其他字段，以插入另一个联系人（更复杂）的信息，而无需覆盖以前的信息
c）能够在此执行的信息很棒使用Spresheets的操作。如果不可能，欢迎其他替代方案。
预先感谢:)
编辑：我在电子表格的链接下方分享：
文件b-
在此处还添加了所需的输出，作为一个工作表
file a- https://docs.google.com/spreadsheets/d/1WXZWauTn91rits3d9a7ioPrOGFGJ8wwBtfevwFUbFPo/edit#gid=109937038
It is my 1s time accessing this forum to ask for help, so excuse in advance for any rookie mistake.
Context: I am creating a database of prospecting contacts to implement a B2B Sales Strategy for a Bespoke Software Dev. Company. I started to build this database manually as an MVP, but soon perceived opportunities to optimize it gathering data with the help from prospecting platforms (such as Apollo).
My challenge: I want to transpose specific data from the 1st 7 columns columns from spreadsheet file A (1st image, yellow fields) to spreadsheet file B (2nd image) based on a query that uses the name of the company in file 2 as a querying criteria and returns data from the 7 yellow columns
File A
File B
Important Notes:
A) When querying from file B 'company' there might be more than 1 contact per company. In this case, the query should either i) return the 1st name, ii) return an error message OR iii) create an additional field at file B to insert information on another contact (more complex)
B) When querying from file B 'company' the column rows in file B might be already filled with previous information from other contacts. In this case, the query should either i) return an error message OR ii) create an additional field at file B to insert information on another contact (more complex) without overwriting previous information
C) It would be great to be able to perform there operations using spreasheets. In case it is not possible, other alternatives would be welcome.
Thanks in advance :)
Edit: I am sharing below the link of the spreadsheets:
File B - https://docs.google.com/spreadsheets/d/1YuOHzwIjhWUGGK6tO-Kx-r-HqGBX_WUhyeHvK121Hms/edit#gid=1966093157
Also added desired output as a sheet here
File A - https://docs.google.com/spreadsheets/d/1WXZWauTn91rits3d9a7ioPrOGFGJ8wwBtfevwFUbFPo/edit#gid=109937038
发布评论
评论（1）
要从文件a到文件b尝试导入电子邮件地址：
=“ nofollow noreferrer”> demo
for importing email addresses from File A to File B try:
demo