vlookup

[Guest]

Hi
I have the following formual in VBA and I keep getting the #NA in the ouput
cell and I dont know why.

Dim stNumber As String
Dim stans As Variant

stNumber = cobStore.Value
stans = Application.VLookup(stNumber,
Worksheets("Numbers").Range("A2:B188"), 2)

Range("I15").Value = stans

can someone please help.

Thanks
Noemi

 

[Bryan Hessey]

Is it possible that cobStore.Value is less than the value in A2 (of the
range)?

Try dropping stans into a spare cell to ensure the 'lookup' is valid.

Hope this helps