nicholasho
New Member
- Joined
- Oct 10, 2005
- Messages
- 6
Hi,
I am trying to perform multiple-column lookup in a table in VBA. I have successfully used & operator to achieve that in inputing similar formular in a sheet. However, I can't get it right in converting it to statements in VBA.
Set RangeOne = Worksheets("Sheet5").Range("$AX$2:$AX$2053")
Agreement = Application.WorksheetFunction.Index(RangeOne, Application.WorksheetFunction.Match(CurrOrder & CurrPart, Worksheets("Sheet5").Range("A2:A2503") & Worksheets("Sheet5").Range("K2:K2503") , 0))
I got "Run time error 13, type mismatch".
Thanks
Nick
I am trying to perform multiple-column lookup in a table in VBA. I have successfully used & operator to achieve that in inputing similar formular in a sheet. However, I can't get it right in converting it to statements in VBA.
Set RangeOne = Worksheets("Sheet5").Range("$AX$2:$AX$2053")
Agreement = Application.WorksheetFunction.Index(RangeOne, Application.WorksheetFunction.Match(CurrOrder & CurrPart, Worksheets("Sheet5").Range("A2:A2503") & Worksheets("Sheet5").Range("K2:K2503") , 0))
I got "Run time error 13, type mismatch".
Thanks
Nick