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
Bookmarks