Excel vlookup帮助 [英] Excel vlookup help

问题描述

使用vlookup，当发生匹配时，我想从表2中显示匹配发生的同一行的列C的值。我想出的公式取C列表2中的值，但是从表3中粘贴了公式的行，而不是匹配发生的位置。

Using vlookup, when a match occurs, I want to display the value of column C from sheet 2 from the same row where the match occurred. The formula I came up with takes the value from column C sheet 2 but it takes it from the row where the formula is pasted on sheet 3 instead of where the match occurred.

这是我的公式不起作用：

Here's my formula that doesn't work:

=IF(VLOOKUP(Sheet1!A:A,Sheet2!A:A,1,FALSE),Sheet2!C:C,"NODATA")

推荐答案

您需要手动获取要查找的索引，然后获取该索引值：

You need to manually get the index you're looking for, then get the value at that index:

=INDEX(Sheet2!C:C, MATCH(Sheet1!A:A,Sheet2!A:A,FALSE))

这篇关于Excel vlookup帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！