I think the issue may be with the table. The data we are looking up may be
26754, but the lookup table reference has the number as '26754. Is there any
way to fix this?

"steph44haf" wrote:

Column A =IF('PM & PDA Use-PO Data Entry'!B3=0," ",'PM & PDA Use-PO Data
Entry'!B3)
Column B =VLOOKUP(A1,Sheet2!$A$1:$B$17000,2,FALSE)

If Column A = 16354-XL, Column B gives correct description ex "Gloves"
If Column A = 26754, Column B can't find match and gives "#N/A"
If we type in 26754 (instead of formula) in Column A, Column B gives correct
desctiption ex "Hats"

Thanks,

Steph