查找包含两个特定值的行数? [英] Find the number of a row that contains two specific values?
问题描述
我觉得我需要使用匹配功能,但不能完全弄清楚。有人知道如何做吗?
您可以使用 MATCH
在这样的数组公式中
= MATCH(1,(A:A = Q1)*(B:B = R1) 0)
需要使用 CTRL + SHIFT + ENTER
....或添加 INDEX
函数,公式可以正常输入
= MATCH(1,INDEX((A:A = Q1)*(B:B = R1),0),0) / code>
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?
You can use MATCH
in an "array formula" like this
=MATCH(1,(A:A=Q1)*(B:B=R1),0)
which needs to be confirmed with CTRL+SHIFT+ENTER
....or add an INDEX
function and the formula can be entered normally
=MATCH(1,INDEX((A:A=Q1)*(B:B=R1),0),0)
这篇关于查找包含两个特定值的行数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!