HLookup与嵌套MATCH [英] HLookup with a nested MATCH

问题描述

我正在将目标文本中的文本返回。 D13包含文本。

I'm trying to return the text in the cell below my target. D13 contains text.

=HLOOKUP(D13,'Sheet1'!$E:$E,MATCH(D13,'Sheet1'!$E:$E,0)+1,FALSE)

给我一​​个＃N / A （值不可用）错误。任何想法？

Gives me a #N/A (Value Not Available) error. Any thoughts?

推荐答案

尽可能多地尝试解释问题作为建议的答案：

As much to try and explain the question as the suggested answer:

=INDEX(Sheet1!$E:$E,MATCH(D13,Sheet1!$E:$E,0)+1)  

似乎有效，假设布局为：

which seems to have worked, assume a layout as:

MATCH 在ColumnE中查找单元格D13的内容（即 dthirteen ）。它在E4中找到完全匹配，因此返回 4 ，列表中的dthteen的位置（E：E）。 （列表从Row1开始，所以第四个位置方便地是Row4。） INDEX 看起来，这里列在同一列 E 中，由第二个参数给出的位置是什么。第二个参数是 4 ，如上所述，加上规定要求的 1 作为偏移量， code> dthirteen 位于。

MATCH looks for the content of cell D13 (ie dthirteen) in ColumnE. It finds an exact match in E4 and hence returns 4, the position of 'dthirteen' in the list (E:E). (The list starts in Row1 so the fourth position is, conveniently, Row4.) INDEX looks, here in the same column E, for what is in the position given by its second parameter. The second parameter is 4, as above, plus the 1 required, by the specification, as an offset to wherever dthirteen is located.

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