VLOOKUP example not working...
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
|