求解,感谢!excel当某一单元格值等于另一列中的值时,显示同一行另一列...答:D5公式:=IF(OR(B5=Sheet1!C$5:C$100),VLOOKUP(B5&"定金",IF({1,0},Sheet1!C$5:C$100&Sheet1!D$5:D$100,Sheet1!E$5:E$100),2,0),"")数组公式,按CTRL+SHIFT+回车,下拉;G5公式:=IF(OR(B5=Sheet1!C$5:C$100),VLOOKUP(B5&"定金",IF({1,0},Sheet1!C$5:C$100&...