software

Good day all,

I am trying to perform a vlookup in a (sorted) list of 705 items;

=VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$705,2)

However, whenever I add more than 300 in my lookup range, it returns an
incorrect value;

IE: if I do =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$300,2), it returns the
proper value...

If I do =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$301,2), it returns incorect
data...

is there a maximum range of cell to use? If there is one, what would you
suggest I use to lookup in my list of 700 items?

Thanks amp; Regards
Hi Fred,

A little hard to say for sure, but I would start with the using FALSE in the
4th argument in your formula.

Your range is set to absolute in the formulas you show here, so I assume
they are in your sheet. If not, that may be the problem.

HTH
Regards,
Howard

quot;Fredquot; gt; wrote in message
...
gt; Good day all,
gt;
gt; I am trying to perform a vlookup in a (sorted) list of 705 items;
gt;
gt; =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$705,2)
gt;
gt; However, whenever I add more than 300 in my lookup range, it returns an
gt; incorrect value;
gt;
gt; IE: if I do =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$300,2), it returns the
gt; proper value...
gt;
gt; If I do =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$301,2), it returns incorect
gt; data...
gt;
gt; is there a maximum range of cell to use? If there is one, what would you
gt; suggest I use to lookup in my list of 700 items?
gt;
gt; Thanks amp; Regards
gt;
gt;
Forgot to mention, there is no real limit for vlookup. I've heard posters
mention having 8 to 15 thousand.

Howard

quot;Fredquot; gt; wrote in message
...
gt; Good day all,
gt;
gt; I am trying to perform a vlookup in a (sorted) list of 705 items;
gt;
gt; =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$705,2)
gt;
gt; However, whenever I add more than 300 in my lookup range, it returns an
gt; incorrect value;
gt;
gt; IE: if I do =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$300,2), it returns the
gt; proper value...
gt;
gt; If I do =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$301,2), it returns incorect
gt; data...
gt;
gt; is there a maximum range of cell to use? If there is one, what would you
gt; suggest I use to lookup in my list of 700 items?
gt;
gt; Thanks amp; Regards
gt;
gt;
quot;Fredquot; wrote:
gt; I am trying to perform a vlookup in a (sorted) list of 705 items;
gt; =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$705,2)
gt; However, whenever I add more than 300 in my lookup range, it returns an
gt; incorrect value;
gt; IE: if I do =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$300,2), it returns the
gt; proper value...
gt; If I do =VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$301,2), it returns incorect
gt; data...
gt;
gt; is there a maximum range of cell to use? If there is one, what would you
gt; suggest I use to lookup in my list of 700 items?

One guess ..

Try an exact* VLOOKUP instead:
=VLOOKUP(quot;D$2$quot;,Business_Data!A$1:C$705,2,0)
*with 4th param set to zero, or FALSE
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---