Hello,
I have a general question about VLOOKUPs. I do a report that pulls some info off of another spreadsheet via vlookup. The report I'm pulling from is not always the same number of rows, so the range I use in my vlookup on my report file is $1:$65536, basically "VLOOKUP-ing" against the entire sheet. The data is usually only around 75-100 lines. I am thinking of changing the range to be $1:$1000 or even less. I want to make sure I always capture all the data on the sheet I'm pulling from, but will I see a significant decrease in calculation time by limiting the range in the VLOOKUP to only 1000 or maybe 500 lines as opposed to the whole sheet?
Basically, it comes down to this: does VLOOKUP take significant time examining all the empty rows in the range, or is it smart enough to sort of ignore them when calculating?
Thanks,
I have a general question about VLOOKUPs. I do a report that pulls some info off of another spreadsheet via vlookup. The report I'm pulling from is not always the same number of rows, so the range I use in my vlookup on my report file is $1:$65536, basically "VLOOKUP-ing" against the entire sheet. The data is usually only around 75-100 lines. I am thinking of changing the range to be $1:$1000 or even less. I want to make sure I always capture all the data on the sheet I'm pulling from, but will I see a significant decrease in calculation time by limiting the range in the VLOOKUP to only 1000 or maybe 500 lines as opposed to the whole sheet?
Basically, it comes down to this: does VLOOKUP take significant time examining all the empty rows in the range, or is it smart enough to sort of ignore them when calculating?
Thanks,