Thread: [Solved] LOOKUP and IF FUNCTION
View Single Post
 
Old 12-06-2013, 09:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Well for a couple of thousand rows, it won't matter. When you reach larger numbers, the slowdown will be significant.
If one then continues retrieving data, say in the same row, using VLOOKUP, then adds some nice cosmetic formatting, or CF, trouble begins, sheets crash, etc..
So, IMO it's better to start things thinking about what will happen in the future with the sheet to avoid problems later on
But then again, that is a personal opinion . ( though I've seen it shared by many XL champions)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote