将数据表中的几个列连接到另一个表
我已经搜索了这一切，并看到了一些参考VLOOKUP和INDEX/MATCH。
从我所能收集到的是，这些函数使用了某种类型的额外引用来工作。
我有一个有很多列的大数据表。我试图将数据从几个特定的列复制到另一个工作表，然后在新工作表上有列，作用于该数据。
如何在没有过滤或汇总的情况下将列直接复制到另一个工作表?
同样，我已经看到了VLOOKUP和IDEX/MATCH的推荐。如果这是我所寻找的，我可能需要一点更深入的解释来操作函数。
任何帮助将不胜感激。
克里斯
答案
-
乔恩·马克 ✭✭✭✭
嗨,克里斯!
你能再详细说说你想做什么吗:
1)。您是在新的/更薄的数据表中使用大数据表中的每一行，还是只使用特定的行?
2)。这两张纸之间是否有某种共享的，独特的参照?(例如，部件编号、部件名称、活动?)
如果要使用所有的行，或者两个工作表上都没有唯一的引用，那么可以链接整个列
方法如下:
步骤1)。创建一个您想要链接的列(在我的例子中，我将我的列命名为“Linked column”)
步骤2)。右键单击你想要数据所在列的TOP单元格，并选择“从其他工作表的单元格链接”
步骤3)。为要链接的列选择列标题。(此处选择“任务名称”)
步骤4)。点击“创建链接”——这将从另一个表格中拉出该栏中的所有数据到新的精简表格中。可以对多个列重复此操作。
让我知道这是否满足您的需求，或者是否您只有特定的行想要停/在两个表上有一个唯一的标识符-在这种情况下，您将想要使用索引/匹配。
如果你需要其他帮助，也请告诉我!
乔恩马克
-
她名叫Stara ✭✭✭✭✭✭我希望你一切安好!
我建议将表与索引/匹配与自动编号列相结合。
大概是这样。
=指数({ColumnWithTheValueYouWantToShow};匹配((电子邮件保护)；{ColumnWithTheValueToMatchAgainsTheCell};0))根据您所在的国家/地区，您需要将逗号替换为句点，将分号替换为逗号。
有意义吗?
那有用吗?
我希望这能有所帮助!
注意安全，祝你周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请通过以下方式支持社区将其标记为有见地/投票赞成或/和作为可接受的答案．这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时联系我有关Smartsheet的帮助，集成，一般的工作流程建议，或其他完全的东西。
-
Chood ✭在我的主表中，我有很多列，里面有很多不同的不相关的信息，关于我要做什么。
我正试图引入一些列到干净的工作表，以执行计算和自动化。
例如，我希望将技术员名称、协调员名称、执行的活动和执行的产品活动移到新表中。ob欧宝娱乐app手机下载
在新的工作表中，我希望填充一个预期收入列，该列将由基于活动和产品的自动化操作确定。ob欧宝娱乐app手机下载我可以这样做，但我很难掌握实时将数据复制到收入表的函数的语法概念。
上面的第一个建议很有效，但它似乎只适用于表中已经存在的内容。当新行被添加到捐赠工作表时，它不会被转移到第二个工作表。
我试着理解第二个建议的语法。我几乎明白了，但仍然在努力。
下面是我的屏幕截图。如果我能得到适用于我的情况的语法，我的灯泡可能会亮起来，我将出发去比赛。
见下文:
我想要数据来自的列称为Assigned Tech，它位于协调表(源表)上。
当我被要求在公式中引用另一个表后选择这一列时，它显示为:
协调表
我希望数据出现在的目标表称为技术员收入表。
我想要数据出现的列叫做:
技术员的名字
数据将被输入到协调表(源表)中，当它们被输入到协调表时，需要在技术人员收入表(目的表)中填充某些列。它只需要是1对1的复制。
我尝试了上面的公式:
=指数({ColumnWithTheValueYouWantToShow};匹配((电子邮件保护)；{ColumnWithTheValueToMatchAgainsTheCell};0))但一定是在语法或哪个列或单元格名称放在哪里混淆了。
很抱歉我理解得有点慢。
克里斯
-
heyjay ✭✭✭
.．.
类别
Thank you for the quick reply kirstie858<\/strong><\/a>!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-06 04:04:01","updateUser":{"userID":155650,"name":"vponis","url":"https:\/\/community.smartsheet.com\/profile\/vponis","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu123eObw5fLQtcthrpqsoWY319L3hmQyAsPTpm6=s96-c","dateLastActive":"2022-12-06T04:02:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":98392,"type":"question","name":"Summary Formula Result in new Formula","excerpt":"I am generating multiple results in a Summary Sheet. I would like to use these results in a new formula within the same Summary, is this possible? SS_Result1 SS_Result2 new formula =sum([SS-Result1]-[SS-Result2]) otherwise I have to combine the formulas within each against themselves, kinda tedious","categoryID":321,"dateInserted":"2022-12-04T20:14:28+00:00","dateUpdated":null,"dateLastComment":"2022-12-05T14:48:26+00:00","insertUserID":154303,"insertUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154303,"lastUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3340437774,"url":"https:\/\/community.smartsheet.com\/discussion\/98392\/summary-formula-result-in-new-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98392\/summary-formula-result-in-new-formula","format":"Rich","lastPost":{"discussionID":98392,"commentID":353136,"name":"Re: Summary Formula Result in new Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/353136#Comment_353136","dateInserted":"2022-12-05T14:48:26+00:00","insertUserID":154303,"insertUser":{"userID":154303,"name":"SkiPatrolScott","url":"https:\/\/community.smartsheet.com\/profile\/SkiPatrolScott","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-05T17:39:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-05T14:48:17+00:00","dateAnswered":"2022-12-04T23:22:27+00:00","acceptedAnswers":[{"commentID":353095,"body":"
![https:\/\/us.v-cdn.net\/6031209\/uploads\/O4WGGWDZB67A\/image.png<\/a><\/p>The destination sheet I want the data to appear in is called Technician Revenue Sheet.<\/p>The column I want the data to appear in is called:<\/p>Technician Name<\/p>https:\/\/us.v-cdn.net\/6031209\/uploads\/YK29AUB67NV0\/capture-png.png<\/a><\/p>The data will be entered into the Coordination Sheet (Source Sheet) and certain columns need to be populated on the Technician Revenue Sheet (Destination Sheet) as they are entered into the Coordination Sheet. It just needs to be 1 for 1 copy as it happens.<\/p>I tried the formula above:<\/p>=\nINDEX({ColumnWithTheValueYouWantToShow}; \nMATCH(CellThatHaveTheValueToMatch@row; {ColumnWithTheValueToMatchAgainsTheCell}; 0))\n<\/pre>But must be confused on the syntax or which Column or Cell name to put where.<\/p>I am sorry to be slow on the uptake here.<\/p>Chris<\/p>","bodyRaw":"[{\"insert\":\"In my main sheet, I have a lot of columns for a lot of different irrelevant information for what I am trying to do.\\nI am trying to bring in just a few columns to the clean sheet to perform calculations and automations on.\\nFor instance, I want the Technician name, Coordinators name, activity performed and product activity was performed on brought over to the new sheet. \\nOnce in the new sheet, I want to populate an expected revenue column that will be determined by automations based on activity and product. I can do this, but I am having a hard time grasping the concept of syntax for the functions to copy the data to the revenue sheet in real time.\\nThe first recommendation above works well, but it seems to only apply to what is already in the sheet. When new rows are added to the doner sheet, it does not get carried over to the second sheet.\\nI tried understanding the syntax of the second suggestion. I ALMOST get it, but am still struggling.\\nBelow is what I have with screen captures. If I can get the syntax as it applies to my situation, My light bulb may come on and I will be off to the races.\\nSee Below:\\nThe column I want the data to come from is called Assigned Tech and it lives on the Coordination Sheet (Source Sheet).\\nWhen I select this column after being asked to reference another sheet in the formula it appears as:\\nCoordination Sheet Range 1\\n\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O4WGGWDZB67A\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O4WGGWDZB67A\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The destination sheet I want the data to appear in is called Technician Revenue Sheet.\\nThe column I want the data to appear in is called:\\nTechnician Name\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/YK29AUB67NV0\\\/capture-png.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/YK29AUB67NV0\\\/capture-png.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The data will be entered into the Coordination Sheet (Source Sheet) and certain columns need to be populated on the Technician Revenue Sheet (Destination Sheet) as they are entered into the Coordination Sheet. It just needs to be 1 for 1 copy as it happens.\\nI tried the formula above:\\n=\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"INDEX({ColumnWithTheValueYouWantToShow}; \"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"MATCH(CellThatHaveTheValueToMatch@row; {ColumnWithTheValueToMatchAgainsTheCell}; 0))\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"But must be confused on the syntax or which Column or Cell name to put where.\\nI am sorry to be slow on the uptake here.\\nChris\\n\"}]","format":"rich","dateInserted":"2022-04-30T14:14:25+00:00","insertUser":{"userID":147532,"name":"Chood","url":"https:\/\/community.smartsheet.com\/profile\/Chood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-16T13:30:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/327955#Comment_327955","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/327955#Comment_327955](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/O4WGGWDZB67A\/image.png\"){kind=link}
![https:\/\/us.v-cdn.net\/6031209\/uploads\/YK29AUB67NV0\/capture-png.png<\/a><\/p>The data will be entered into the Coordination Sheet (Source Sheet) and certain columns need to be populated on the Technician Revenue Sheet (Destination Sheet) as they are entered into the Coordination Sheet. It just needs to be 1 for 1 copy as it happens.<\/p>I tried the formula above:<\/p>=\nINDEX({ColumnWithTheValueYouWantToShow}; \nMATCH(CellThatHaveTheValueToMatch@row; {ColumnWithTheValueToMatchAgainsTheCell}; 0))\n<\/pre>But must be confused on the syntax or which Column or Cell name to put where.<\/p>I am sorry to be slow on the uptake here.<\/p>Chris<\/p>","bodyRaw":"[{\"insert\":\"In my main sheet, I have a lot of columns for a lot of different irrelevant information for what I am trying to do.\\nI am trying to bring in just a few columns to the clean sheet to perform calculations and automations on.\\nFor instance, I want the Technician name, Coordinators name, activity performed and product activity was performed on brought over to the new sheet. \\nOnce in the new sheet, I want to populate an expected revenue column that will be determined by automations based on activity and product. I can do this, but I am having a hard time grasping the concept of syntax for the functions to copy the data to the revenue sheet in real time.\\nThe first recommendation above works well, but it seems to only apply to what is already in the sheet. When new rows are added to the doner sheet, it does not get carried over to the second sheet.\\nI tried understanding the syntax of the second suggestion. I ALMOST get it, but am still struggling.\\nBelow is what I have with screen captures. If I can get the syntax as it applies to my situation, My light bulb may come on and I will be off to the races.\\nSee Below:\\nThe column I want the data to come from is called Assigned Tech and it lives on the Coordination Sheet (Source Sheet).\\nWhen I select this column after being asked to reference another sheet in the formula it appears as:\\nCoordination Sheet Range 1\\n\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O4WGGWDZB67A\\\/image.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/O4WGGWDZB67A\\\/image.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The destination sheet I want the data to appear in is called Technician Revenue Sheet.\\nThe column I want the data to appear in is called:\\nTechnician Name\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/YK29AUB67NV0\\\/capture-png.png\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/YK29AUB67NV0\\\/capture-png.png\"}},{\"insert\":\"\\n\"},{\"insert\":\"The data will be entered into the Coordination Sheet (Source Sheet) and certain columns need to be populated on the Technician Revenue Sheet (Destination Sheet) as they are entered into the Coordination Sheet. It just needs to be 1 for 1 copy as it happens.\\nI tried the formula above:\\n=\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"INDEX({ColumnWithTheValueYouWantToShow}; \"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"MATCH(CellThatHaveTheValueToMatch@row; {ColumnWithTheValueToMatchAgainsTheCell}; 0))\"},{\"attributes\":{\"code-block\":true},\"insert\":\"\\n\"},{\"insert\":\"But must be confused on the syntax or which Column or Cell name to put where.\\nI am sorry to be slow on the uptake here.\\nChris\\n\"}]","format":"rich","dateInserted":"2022-04-30T14:14:25+00:00","insertUser":{"userID":147532,"name":"Chood","url":"https:\/\/community.smartsheet.com\/profile\/Chood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-08-16T13:30:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/327955#Comment_327955","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/327955#Comment_327955](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/YK29AUB67NV0\/capture-png.png\"){kind=link}