eggyjla
Active Member
- Joined
- Dec 16, 2004
- Messages
- 346
I have 10,000+ rows where one of the two forms is copied into A:A, C:C, E:E, G:G and I:I. I'm wondering which of the two is the preferred approach for keeping the recalculate time low. Which should take less time or less computing resources, or are would they be the same? I created two files, one withe each formula and the file size of both workbooks appear to be nearly the same.
Code:
=IF(ISBLANK(B1),"",VLOOKUP(B1,$M$1:$N$10,2,))
Code:
=IF(LEN(B1),VLOOKUP(B1,$M$1:$N$10,2,),"")