怎样在Excel中跨表单显示两列字符答:sheet1的C5输入公式:=VLOOKUP(B5,sheet2!A:B,2,0)下拉填充。可加上排错语句:=IF(ISERROR(VLOOKUP(B5,Sheet2!A:B,2,0)),"",VLOOKUP(B5,Sheet2!A:B,2,0))
vb里怎么跨数据表 直接引用 VLOOKUP函数,代码正确立即采纳答:Sub gTEd()Dim arr, brrarr = Sheet2.UsedRangebrr = Sheet1.UsedRangeFor a = 2 To UBound(arr) arr(a, 4) = WorksheetFunction.VLookup(arr(a, 1), brr, 2, 0)NextSheet2.[a1].Resize(UBound(arr, 1), UBound(arr, 2)) = arrEnd Sub ...