Application.WorksheetFunction.Lookup(using array variable)

[MattOCUSA]

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?

 

[jindon]

try

Sub Sample()
Dim myArray, myValue, myResult
' generate 2d array
myArray = [{1,"Number1";2,"Number2";3,"Number3";4,"Number4"}]
myValue = Range("a1").Value
On Error Resume Next
myResult = WorksheetFunction.VLookUp(myValue, myArray, 2, False)
If Err <> 0 Then myResult = "#N/A"
MsgBox myResult
End Sub

 

[MattOCUSA]

Cool, works. It was missing a "{" initially but other than that, worked like a charm!

Your the man.

I notice you caught the "{" since I initially copied it, thank you again!!!

 

[jindon]

I notice you caught the "{" since I initially copied it, thank you again!!!

Yup!