查找返回第一行 [英] Lookup Return Top Row

问题描述

我正在尝试在Google文档中进行查找，以返回找到项目的第一行.我已经附上了我的数据的示例图像.数据在F2:Q25中，我想提供一个数字并使它返回相应的团队.例如，如果我输入1，我希望它返回Team1.如果输入79，我希望它返回Team7(找到结果的第一行).

I am trying to do a Lookup in Google Docs that returns the top row of where an item was found. I have attached an example image of my data. The data is in F2:Q25 and I want to supply a number and have it return the corresponding team. For example, if I enter in 1, I want it to return Team1. If I enter 79, I want it to return Team7 (the top row of where the result was found).

这可能吗?

推荐答案

使用数学排除原理(通过在不匹配的所有内容上加上天文数以找到最小的原理)与

Use the principle of mathematical exclusion (find the smallest by adding an astronomical amount to everything that does not match) with the INDEX and MIN functions.

=index(A:Q, 1, min(index(column(F:Q)+($F$2:$Q$13<>C5)*1E+99, , )))

这篇关于查找返回第一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！