excel函数,vlookup怎样操作同时满足2个条件的匹配?答:E3公式:=VLOOKUP(B3&C3,IF({1,0},Sheet1!B$3:B$100&Sheet1!C$3:C$100,Sheet1!E$3:E$100),2,)数组公式,需要按CTRL+SHIFT+回车,完成公式;E4公式:=VLOOKUP(B3&C3,IF({1,0},Sheet1!B$3:B$100&Sheet1!C$3:C$100,Sheet1!E$4:E$101),2,)数组公式,需要按CTRL+SHIFT+...