Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup maximum cell range?
Good day all,
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? Thanks & Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
cell address rather than range name | Excel Discussion (Misc queries) | |||
Date Range within one cell | New Users to Excel | |||
macro help | Excel Discussion (Misc queries) | |||
Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions |