VLOOK TABLE Index doesn't work

[MakboolAhmed]

Iam trying to Vlook from one work book to another work. Cursor is locating correctly but not picking up the lookup value.


Dim LValue as String

lookFor = Internal_Sheet.range("A2").value
Set IFRange = Snow_Sheet.Range("A1:I200")

LValue = Application.worksheetfunctions.Vlookup(lookFor, IFRange, 2, False)

 

[mole999]

what would lookfor be in the cell, text or number or text number?

 

[MakboolAhmed]

Lookfor returns a string..

 

[DanteAmor]

Use Find Method.
Try this:

Dim LValue as String, f as range

lookFor = Internal_Sheet.range("A2").value
Set IFRange = Snow_Sheet.Range("A:A")
If isnumeric(lookfor) then lookfor = val(lookfor)
Set f = IFRange.find(lookfor, lookin:=xlvalues, lookat:=xlwhole)
If not f is nothing then
Lvalue = f.offset(0,1)
Else
Msgbox "not exists"
End if