View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian
 
Posts: n/a
Default vlookup returning a #N/A value

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??