Posted to microsoft.public.excel.worksheet.functions

Ian

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP not returning results	Chris Kellock	Excel Worksheet Functions	14	March 19th 08 08:30 AM
vlookup returning sum	Rose	Excel Worksheet Functions	1	July 14th 05 10:47 PM
Vlookup returning #N/A	ww	Excel Worksheet Functions	2	March 23rd 05 12:24 AM
MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT.	Martin	Excel Discussion (Misc queries)	2	December 13th 04 11:21 AM
troubleshoot vlookup returning #N/A	dillon	Excel Worksheet Functions	1	December 2nd 04 03:32 PM

All times are GMT +1. The time now is 04:10 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us