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



Noemi Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=475320