从表返回某个值
嗨，大家，在excel和我解释一切方面可能有点''''''
'索引和匹配功能（我不是Excel的专业人士，只是试图减轻我的工作，到目前为止，Google帮助了我并做了很多事情，但是我无法真正看到的这一特殊的事情，希望有人可以帮助您 因此，
在表1上，除了每天在
表2上更改的Reg，van，van，d2 cell的 。
）
驾驶室，一切都将保持不变。数字
Hi guys , might be a bit ''noob'' in terms of excel and the way i explain everything but here we go :
I've been messing around with Vlookup , index and match functions ( I'm not a pro with excel , just trying to ease my job , so far google helped me and made a lot of things, but this particular one I can't really see it through , hope someone can help.
So on Table 1 everything will stay the same except the REG , VAN , provider , Model that will change on a daily basis.
On Table 2 in D2 cell i want to return the value from Table1 (Driver's name of who is assigned that registration number ).
Reason for that is i have around 150 entries , and sometimes i need for random checks around 10-15, and (ctr+f , copy , paste , create another table is time consuming )
Thank you in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
由于表数据不可用，我创建了几列来消除您需要做的事情。
Vlookup将无法正常工作，因为它希望查找值在第一列中。
我已经使用了索引/匹配项，并且效果很好。您可以使用类似的一个将列名称更改为表格中的正确列。请注意，在我的示例中，
table1在Sheet1table2 中是同一Excel工作簿中的Sheet2。对于
table2-驱动程序列，您需要公式为= index（Sheet1！A2：A6，Match（A2，Sheet1！C2：C2：C6,0）））可以向下拖动单元格，以便正确识别所有行。在Sheep1/Table1中 - 驱动程序在A列中，REG在C列中。 和a2：a6。如果您有更多的行，则需要相应地更改。让我知道您是否面临问题。还要连接两个表，以便您可以关联。as the table data was not available, I created a few columns to demonstate what you would need to do.
VLOOKUP will not work as it expects the lookup value to be in the first column.
I have used the Index/match and it works fine. You can use similar one changing the column names to the correct columns in your sheet. Note that
TABLE1in inSheet1andTABLE2is inSheet2of the same excel workbook in my example.For the
TABLE2 - DRIVERcolumn, you need the formula as=INDEX(Sheet1!A2:A6,MATCH(A2,Sheet1!C2:C6,0))and you can drag the cell down so that all rows are correctly identified. In Sheet1/TABLE1 - DRIVER is in column A and REG is in column C. In Sheet2/TABLE 2, REG is in column A. There is one header and 5 rows of data, so the values are fromC2:C6andA2:A6. If you have more rows, you will need to change accordingly. Let me know if you face issues. Also attaching the two tables so you can relate.