Unable to Get VLookup Property for worksheet function class

[Shantanu_4612]

Hi All,

I am getting "Unable to VLookup property of the Worksheets Function Class" Erro for the below code.

Kindly assist

I am using this code in a userform

Private Sub ListBox1_Click()

Dim l As Integer
Dim f As Integer


EST.TextBox6 = EST.ListBox1

l = Len(EST.TextBox6)
f = InStr(EST.TextBox6, " *")

EST.TextBox1 = Mid(EST.TextBox6, 1, (l - (l - (InStr(EST.TextBox6, " *")))))


EST.TextBox8 = EST.TextBox5 & EST.TextBox1



EST.TextBox3 = Application.WorksheetFunction.VLookup(EST.TextBox8, Worksheets("TempRAW").Range("A1:J1000000"), 10, False)

EST.TextBox2.Text = Application.WorksheetFunction.VLookup(EST.TextBox8, Worksheets("TempRAW").Range("A1:G1000000"), 7, False)







End Sub

 

[pgc01]

Hi

That usually means that the text you are searching was not found.

 

[Shantanu_4612]

Hi,

I checked the RAW,

Data is available for the Look up

 

[Norie]

Is the data in column A on the sheet 'TempRAW' numeric or text?

PS If you are trying to find the row in A that matches the value in the textbox probably better to use MATCH.

 

[pgc01]

Hi,

I checked the RAW,

Data is available for the Look up

Well, you did not post any data nor any example and so it's difficult to know exactly what's happening.

For ex. you may have the text "3" in the textbox and the RAW data has the number 3 and so you get the error.

Post a small example with some data and what you're looking for so that we can test.