Hi Ian,
Mixing text and number formats will create problems.
Try converting both the source and destinaiton columns to text.
Select the entire column and go to Data Text to Columns...
In that dialog box click next until you get to Step 3 and select text.
See if that works for you.
--
Ken Hudson


"Ian" wrote:

Problem with vlookup returning #N/A value in only some of the worksheet
I have an inventory of some 4,000 items
The data I'm looking for is in the target worksheet, but vlookup returns
#N/A for some of the results.
I'm wondering if it has to do with the format of item numbers (which are a
combination of numbers & letters).
Would it make a difference if some was number & some text??