If I am doing an Application.WorksheetFunction.Lookup, can I reference a variable I have that is a multi-dimensional Array(2 Rows, 10 Columns) in the lookup?
So I want to lookup:
1) myValue = (which lets say equals the number in Cell ("A1").
2) I want to lookup myValue in the first column of my 2 column Array, called myArray, and give me the results found in the 2nd column of myArray? That must be possible? Could I get a syntax example?
I use 3 variables now: myValue, vFind and vReturn. I want to replace vFind and vReturn with myArray?
So I want to lookup:
1) myValue = (which lets say equals the number in Cell ("A1").
2) I want to lookup myValue in the first column of my 2 column Array, called myArray, and give me the results found in the 2nd column of myArray? That must be possible? Could I get a syntax example?
I use 3 variables now: myValue, vFind and vReturn. I want to replace vFind and vReturn with myArray?