查找包含两个特定值的行号? [英] Find the number of a row that contains two specific values?

问题描述

我有一个包含多列的信息表.第一列是日期"(范围 A:A)，第二列是名称"(范围 B:B).当我在单元格 Q1 中输入日期并在单元格 R1 中输入名称时，我需要一个公式来查找哪一行包含这两个值并输出行号.

I have a table of information with multiple columns. The first column is "Date" (range A:A) and the second column is "Name" (range B:B). When I enter a date into cell Q1 and a name into cell R1, I need a formula that will find which row contains both of those values and output the row number.

我觉得我需要使用匹配功能，但不太明白.有人知道怎么做吗?

I feel like I need to use the match function but can't quite figure it out. Does anyone know how to do this?

推荐答案

你可以在这样的数组公式"中使用MATCH

You can use MATCH in an "array formula" like this

=MATCH(1,(A:A=Q1)*(B:B=R1),0)

需要用CTRL+SHIFT+ENTER

....或者添加一个INDEX函数，公式可以正常输入

....or add an INDEX function and the formula can be entered normally

=MATCH(1,INDEX((A:A=Q1)*(B:B=R1),0),0)

这篇关于查找包含两个特定值的行号?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！