View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default vlookup maximum cell range?

"Fred" wrote:
I am trying to perform a vlookup in a (sorted) list of 705 items;
=VLOOKUP("D$2$",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("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 ..

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