如果 Sheet1 中两列的值与 Sheet2 中的两列匹配，则检索 Sheet 2 单独列中的单元格值
预期的行为
其中两个不同列的同一行中的两个值匹配两个不同列的同一行中的两个值原始纸的第三列。
例如...
其中Sheet1 A2（“ 1”）和 b2（“ a”）匹配 sheet2 a5（“ 1）和b5（“ a”），Sheet2 D5中的值（ 1500％）应显示在Sheep1
中
C2 。
，并尝试将它们处理到我的电子表格中，但是我收回的数据是“”（空白），“ #value”或“ #na”，
以下公式似乎似乎 它从似乎是错误的空白中吐出了空白。
但可悲的是，
要成为最接近的潜在分辨率， ：d7，匹配（Sheet1！A2：A7，Sheet2！A2：A7,0），匹配（Sheet1！B2：B7，Sheet2！B2：B7,0）），）
对此表示赞赏Excel Noob，谢谢:)
Intended behaviour
Where two values in the same row of two different columns MATCH two values in the same row of two different columns in another sheet, the data in the same row of the third column of the additional sheet is displayed in a third column of the original sheet.
For example...
Where Sheet1 A2 ("1") AND B2 ("A") MATCH Sheet2 A5 ("1) AND B5 ("A"), the value in Sheet2 D5 (1500%) should be displayed in C2 of Sheet1
I have read the below similar questions:
Match two columns in table to two columns in separate table and return value &
Match values in two columns and return value using vlookup from third column in Excel
and tried working them into my spreadsheet but the data I get back is either a "" (blank), "#VALUE" or "#NA"
The below formula seems to be the closest potential resolution but sadly it's spitting out blank from what seems to be an error ????
I have also tried the below formula with CSE (Ctrl +Shift + Enter) but nothing ????
=IFERROR(INDEX(Sheet2!D2:D7, MATCH(Sheet1!A2:A7,Sheet2!A2:A7,0),MATCH(Sheet1!B2:B7,Sheet2!B2:B7,0)),)
Any assistance would be appreciated for this excel noob, thank you :)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以在 Sheet1!C2 中尝试此操作：
=INDEX(Sheet2!$D$2:$D$7,MATCH(1,(Sheet2!$A$2:$A$7=Sheet1!A2)*(Sheet2!$ B$2:$B$7=工作表1!B2),0))You can try this in your Sheet1!C2:
=INDEX(Sheet2!$D$2:$D$7,MATCH(1,(Sheet2!$A$2:$A$7=Sheet1!A2)*(Sheet2!$B$2:$B$7=Sheet1!B2),0))