application.match and value problem
 

Have a "data" worksheet,
Column A contains the Item Number with column set to text

Dim val As String
With userforms1


val = Itemnum.Value


If IsError(Application.Match(val, Range("price").Columns(1), 0)) Then


If I enter the item number manually all works.
If I copy and paste values from another worksheet that is e-mailed to me every 3 months with new item numbers and pricing Application.Match will not work.

Help please

ThaNKS cARL