英文:
How to compare multiple data points in Excel
问题
I'm having issues on comparing data to find matches. I'm trying to compare multiple columns to match with a single point in a row. For example A1=Bob B1= phone number C1= address then I try to compare if any of those values match in a different sheet say on D5 = Name G7= phone number J12= address. Then after comparing the data sets it out puts a match if 2 parameters are met. I was thinking that Index(Match) would be the way to go, but I'm not entirely sure. Any suggestions?
Running Index Match would only allow me to compare in one column at a time.
i.e. =index(D6:D15,match(H5,B6:B15,0))
英文:
I'm having issues on comparing data to find matches. I'm trying to compare multiple columns to match with a single point in a row. For example A1=Bob B1= phone number C1= address then I try to compare if any of those values match in a different sheet say on D5 = Name G7= phone number J12= address. Then after comparing the data sets it out puts a match if 2 parameters are met. I was thinking that Index(Match) would be the way to go, but I'm not entirely sure. Any suggestions?
Running Index Match would only allow me to compare in one column at a time.
i.e. =index(D6:D15,match(H5,B6:B15,0))
答案1
得分: 0
创建一个查找列在你的第一个数据集末尾,名称为A1&B1&C1...
,然后在你的索引匹配公式中使用MATCH(A1&B1&c1...,'DataSet1'!X:X,0)
。
英文:
create a lookup column at the end of your first dataset A1&B1&C1...
and use index match and MATCH(A1&B1&c1...,'DataSet1'!X:X,0)
in your index match formula.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论