I am using VLOOKUP with a range of part refs some are numeric only, some are
alphanumeric.

My lookup is working fine with the alphanumerics, but not the numerics.
Please help. I have tried formatting all refs in each worksheet as text to
no avail.