F86的公式为:=VLOOKUP(E86,$B$87:$C$90,2,0)
F87的公式为:=VLOOKUP(E87,$B$87:$C$90,2,0)
F88的公式为:=VLOOKUP(E88,$B$87:$C$90,2,0)
F89的公式为:=VLOOKUP(E89,$B$87:$C$90,2,0)
F91的公式为:=IF(VLOOKUP(E91,$B$87:$C$90,2,0)="","",VLOOKUP(E91,$B$87:$C$90,2,0))
F92的公式为:=IF(VLOOKUP(E92,$B$87:$C$90,2,0)="","",VLOOKUP(E92,$B$87:$C$90,2,0))
责任编辑:八月骄阳