公式如下:
i) Lookup_value - A1 (sheet 1)
Table_array - A1 ~ C600 (sheet 2)
Col_index_num - 2
ii) Lookup_value - A1 (sheet 1)
Table_array - A1 ~ C600 (sheet 2)
Col_index_num - 3
更新1:
抱歉~ 問題描述得唔清楚 以下係我而家用o既公式 : =VLOOKUP(A1,'sheet2'!A1:C600,2) =VLOOKUP(A1,'sheet2'!A1:C600,3) 舉例 : Sheet 2 A1 = E001 B1 = 克色 C1 = 3 mm 橡根 A2 = E002 B2 = 紅色 C2 = 8 x 8 棉繩 Lookup_value係sheet 1內的A1輸入E001 正常B1及C1出現 克色及3mm 橡根,但係出現的是紅色及8 x 8棉繩,我究竟出錯係邊度呢? 請各位幫幫手,唔該!