求excel公式:符合兩個條件的則顯示對應的值
表格1A列和B列与表格2A列和B列一样,则表格1C列显示表格2C列值
在表格1的C1单元格输入公式:
=IF(AND(A1=Sheet2!A1,B1=Sheet2!B1),Sheet2!C1,"")
=IF(AND(A1=Sheet2!A1,B1=Sheet2!B1),Sheet2!C1,""),如果sheet1的A和B与sheet2的A和B相等,sheet1的C显示sheet2的C的值
热门标签:
表格1A列和B列与表格2A列和B列一样,则表格1C列显示表格2C列值
在表格1的C1单元格输入公式:
=IF(AND(A1=Sheet2!A1,B1=Sheet2!B1),Sheet2!C1,"")
=IF(AND(A1=Sheet2!A1,B1=Sheet2!B1),Sheet2!C1,""),如果sheet1的A和B与sheet2的A和B相等,sheet1的C显示sheet2的C的值