Remember Me?

#1
April 3rd 06, 06:27 PM posted to microsoft.public.excel.misc
 Fred Posts: n/a
vlookup maximum cell range?

Good day all,

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

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

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

If I do =VLOOKUP("D\$2\$",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 & Regards

#2
April 3rd 06, 07:36 PM posted to microsoft.public.excel.misc
 L. Howard Kittle Posts: n/a
vlookup maximum cell range?

Hi Fred,

A little hard to say for sure, but I would start with the using FALSE in the

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

"Fred" wrote in message
...
Good day all,

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

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

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

If I do =VLOOKUP("D\$2\$",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 & Regards

#3
April 3rd 06, 07:38 PM posted to microsoft.public.excel.misc
 L. Howard Kittle Posts: n/a
vlookup maximum cell range?

Forgot to mention, there is no real limit for vlookup. I've heard posters
mention having 8 to 15 thousand.

Howard

"Fred" wrote in message
...
Good day all,

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

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

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

If I do =VLOOKUP("D\$2\$",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 & Regards

#4
April 3rd 06, 07:46 PM posted to microsoft.public.excel.misc
 Max Posts: n/a
vlookup maximum cell range?

"Fred" wrote:
I am trying to perform a vlookup in a (sorted) list of 705 items;
However, whenever I add more than 300 in my lookup range, it returns an
incorrect value;
IE: if I do =VLOOKUP("D\$2\$",Business_Data!A\$1:C\$300,2), it returns the
proper value...
If I do =VLOOKUP("D\$2\$",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?

One guess ..

*with 4th param set to zero, or FALSE
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

 Similar Threads Thread Thread Starter Forum Replies Last Post kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM Angi Bemiss Excel Discussion (Misc queries) 1 December 1st 05 01:46 AM Cachod1 New Users to Excel 5 October 18th 05 03:30 AM thephoenix12 Excel Discussion (Misc queries) 4 July 15th 05 05:57 PM Danny O'Hern ([email protected]) Excel Worksheet Functions 0 April 29th 05 01:16 PM

All times are GMT +1. The time now is 11:19 PM.