Posted to microsoft.public.excel.worksheet.functions

ken gault

external usenet poster

Posts: 2

vlookup error

I am using a vlookup that is returning a wrong value. all of the data are
numeric, I have checked for spaces, text and used paste special for values.
the lookup table array is 2 colums x 9903 rows, sorted by the first column.
is there a restriction on the size of the lookup table array?
Thanks
Ken

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 ERROR	DeVoe	Excel Worksheet Functions	3	April 11th 07 09:11 PM
REF# error using VLOOKUP	Amy	Excel Worksheet Functions	8	May 18th 06 01:06 AM
Value Not Available Error in Vlookup	thefeokas	Excel Discussion (Misc queries)	3	April 14th 05 05:57 PM
vlookup error!!	Samantha	Excel Worksheet Functions	1	April 11th 05 11:02 AM
vlookup error	Josh O.	Excel Worksheet Functions	6	December 30th 04 05:16 PM

All times are GMT +1. The time now is 03:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us