put this formula to the "*" place
=IF(ISNA(VLOOKUP(C2,$A$1:$B$7,2,0)),0,VLOOKUP(C2,$A$1:$B$7,2,0))
A B C D E
code1 r1 code2 r2 r1/r2
101 34 101 68 *
102 33 102 67
104 37 103 65
106 35 104 66
107 30 105 62
109 49 106 59
107 55
108 68
109 70 ...


雷达卡
京公网安备 11010802022788号







