What is not working? Do you get #N/A? If so the lookup does not match.
If you get an error message when you try to apply it, open the other
workbook and do the vlookup, that way excel will put in the path for you when
you close the lookup source workbook


Regards,

Peo Sjoblom

"Carole O" wrote:

I'm designing a form that I want, upon the entry of a SKU, will look up the
SKU info on another Server and return the description. This is what I have -
and it isn't working.

=VLOOKUP(C16,\\Canto\Design\OM\[PCSKU.xls]'ALLPROD' !$A$2:$B$2000,2)