I'm struggling to get the syntax correct to use the VLookup function in a Worksheet Macro. The two dimensional table is held in a different worksheet from the active worksheet. The index is held in a string variable "ThisCell", the table is held in "Sheet3" at array A1:B1154. I'm looking for an exact match from column 2 to be placed in the string variable "MyData".
My current attempt is:
MyData=Application.WorksheetFunction.VLookup(ThisCell,"Sheet3"!A1:B1154,2,False)
Many thanks.