vlookup in vba query

[luffield]

I have attached my excel sheet. I am trying to use a vba/vlookup but it does not work.
Can anyone see what is wrong.

The sub is Stockno

Thanks for your assistance.

Luffield

[rylo]

Hi

try changing the line to

Please Login or Register  to view this content.

rylo