=VLOOKUP(G2,单位!$A$2:$C4000,2,FALSE) =VLOOKUP(B2,物料!$A$2:$C4000,2,FALSE) http://js.clicki.cn/ schoolNet:http://www.schoolnet.com/company/ 精英英语教学: http://www.midienglish.com/rev/cn_midi_student1.php 邀请码:8053 这个网站就是咱们在pearson买的教材的在线课程系统 http://connected.mcgraw-hill.com Username: wonders Password: mhe2015reading