| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How many rows (arguments?) can be seached by Vlookup function?
Hi to all
I'm wondering how many rows (are they considered argument?) can be used for a vlookup table? Thanks -- smither fan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How many rows (arguments?) can be seached by Vlookup function?
All of them.
But the more data in the table, the longer excel will take to recalc. =vlookup(a1,sheet2!a:b,2,false) is fine. Ross wrote: Hi to all I'm wondering how many rows (are they considered argument?) can be used for a vlookup table? Thanks -- smither fan -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How many rows (arguments?) can be seached by Vlookup function?
Thanks, Dave
For some reason, I seemed to remember being told that there was a limit to the rows that XL would search through in a vlookup situation, but must have confused it with something else. -- smither fan "Dave Peterson" wrote: All of them. But the more data in the table, the longer excel will take to recalc. =vlookup(a1,sheet2!a:b,2,false) is fine. Ross wrote: Hi to all I'm wondering how many rows (are they considered argument?) can be used for a vlookup table? Thanks -- smither fan -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How many rows (arguments?) can be seached by Vlookup function?
Maybe you were told that an =vlookup() formula like:
=vlookup(a1,sheet2!a:b,2,false) Would limit itself to the usedrange of Sheet2--even though the formula specifies the entire column. Maybe???? Ross wrote: Thanks, Dave For some reason, I seemed to remember being told that there was a limit to the rows that XL would search through in a vlookup situation, but must have confused it with something else. -- smither fan "Dave Peterson" wrote: All of them. But the more data in the table, the longer excel will take to recalc. =vlookup(a1,sheet2!a:b,2,false) is fine. Ross wrote: Hi to all I'm wondering how many rows (are they considered argument?) can be used for a vlookup table? Thanks -- smither fan -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How many rows (arguments?) can be seached by Vlookup function?
Thanks-That does sound more like it.
-- smither fan "Dave Peterson" wrote: Maybe you were told that an =vlookup() formula like: =vlookup(a1,sheet2!a:b,2,false) Would limit itself to the usedrange of Sheet2--even though the formula specifies the entire column. Maybe???? Ross wrote: Thanks, Dave For some reason, I seemed to remember being told that there was a limit to the rows that XL would search through in a vlookup situation, but must have confused it with something else. -- smither fan "Dave Peterson" wrote: All of them. But the more data in the table, the longer excel will take to recalc. =vlookup(a1,sheet2!a:b,2,false) is fine. Ross wrote: Hi to all I'm wondering how many rows (are they considered argument?) can be used for a vlookup table? Thanks -- smither fan -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows with two arguments | Excel Discussion (Misc queries) | |||
| Vlookup Function Arguments are correct but nothing in cell | Excel Worksheet Functions | |||
| Multiple vlookup arguments | Excel Worksheet Functions | |||
| Too many arguments-VLOOKUP instead? | Excel Worksheet Functions | |||
| how do I add new rows when doing vlookup function? | Excel Worksheet Functions | |||
Linear Mode
