EXCEL中如何实现多条件匹配或引用表一9.67.66.54.2AB30020010050AC35023012050AD40026014050AE45029016050AF50032018050AG55035020050AH60038022050AI65041024050AJ70044026050AK75047028050表二AB

来源：学生作业帮助网 编辑：作业帮 时间：2024/04/30 06:32:51
EXCEL中如何实现多条件匹配或引用表一9.67.66.54.2AB30020010050AC35023012050AD40026014050AE45029016050AF50032018050AG55035020050AH60038022050AI65041024050AJ70044026050AK75047028050表二AB

EXCEL中如何实现多条件匹配或引用表一9.67.66.54.2AB30020010050AC35023012050AD40026014050AE45029016050AF50032018050AG55035020050AH60038022050AI65041024050AJ70044026050AK75047028050表二AB
EXCEL中如何实现多条件匹配或引用
表一
9.67.66.54.2
AB30020010050
AC35023012050
AD40026014050
AE45029016050
AF50032018050
AG55035020050
AH60038022050
AI65041024050
AJ70044026050
AK75047028050
表二

AB7.621020010
AC4.250500
AD6.5150--150
AE9.6450--450
AF9.6520--520
AG4.260--60
AH7.6400--400
AI4.250--50
AJ6.5260--260
AK9.67507500
如何在表二中引用出表一中对应的值
如何在表二中引用出表一中"--"对应的值

EXCEL中如何实现多条件匹配或引用表一9.67.66.54.2AB30020010050AC35023012050AD40026014050AE45029016050AF50032018050AG55035020050AH60038022050AI65041024050AJ70044026050AK75047028050表二AB
=INDEX(Sheet1!$B$2:$E$11,MATCH(Sheet2!A6,Sheet1!$A$2:$A$11,),MATCH(Sheet2!B6,Sheet1!$B$1:$E$1,))下拉.