Vba lookup results in #n/a error

[drluke]

I have no idea why the code below results in #n/a error? When I type this vlookup as a 'normal' excel formula it works perfectly!

Range("L1").Value = Application.VLookup(Me.ComboBox1.Value, Sheets("Validation").Range("B2:C13"), 2, 0)

Any advice?

 

[alansidman]

Vlookup is not a VBA function and you need to supplement the code with WorksheetFunction,

Range("L1").Value = Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, Sheets("Validation").Range("B2:C13"), 2, 0)

Look at this link http://www.cpearson.com/excel/CallingWorksheetFunctionsInVBA.aspx

 

[Fluff]

If you are looking up numbers try

Range("L1").Value = Application.VLookup(Val(Me.ComboBox1.Value), Sheets("Validation").Range("B2:C13"), 2, 0)