Solved -Data input from scanner adds extra, how to remove

I think I have an answer(s) for you, but I'm making some assumptions.

If the PickSlip scanned in ALWAYS is supposed to be 6 characters, then you could use this formula in cell D10 to just use the first 6 characters:

=IF(C10="","",VLOOKUP(left(C10,6),Table_ExternalData_1[#All],3,FALSE))

If the Pickslip is always Numeric, with a varying number of digits, and the first 'junk' character is always non-numeric, then try this array formula in D10 (enter by pressing CONTROL-SHIFT-ENTER instead of just ENTER)

=IF(C10="","",VLOOKUP(LEFT(C10,COUNT(--MID(C10,ROW(INDIRECT("1:" & LEN(C10))),1))),Table_ExternalData_1[#All],3,FALSE))

OK still get a #NA error, Why control shift enter? Mine does not add anything if I use this method. BTW I am on Excel 2010.

Whoops, I copied the wrong formula -- I forgot to coerce back to a number.
Use this instead.

=IF(C10="","",VLOOKUP(--LEFT(C10,COUNT(--MID(C10,ROW(INDIRECT("1:" & LEN(C10))),1))),Table_ExternalData_1[#All],3,FALSE))

(the -- changes a text value to a numeric value)
For an array formula to work, it Excel requires it to be entered with that keystroke combination. It should appear in the formula bar with curly brackets ( { =... } around it. Do not try entering these manually. Instead, copy/paste the formula into the formula bar and then press cse.

This worked a charm many thanks for your help now to perfect the timestamp issue. I have posted another post on that but perhaps will do my own with my example.

Yes it is always meant to be the 1st numeric numbers the items from the example +PK these are not needed so to strip those would work. Let me test your coded. Thanks for the rapid reply.

Thanks was just thinking I had something wrong