excel如何通过两个关键字从数据档案库中提取数据?答:sheet1 sheet2 C2=VLOOKUP(A2&B2,IF({1,0},Sheet1!A:A&Sheet1!D:D,Sheet1!B:B),2,0)D2=VLOOKUP(A2&B2,IF({1,0},Sheet1!A:A&Sheet1!D:D,Sheet1!C:C),2,0)数组公式,ctrl+shift+回车确认。如果EXCEL是支持XLOOKUP的版本,SHEET2 C2=XLOOKUP(A2&B2,Sheet1!A:A&Sheet1!D:...