Originally Posted by
FDibbins
A few question/observations...
There is no need to enter a formula like this...
=IF(VLOOKUP(I2,PURGE!I2:S1000,4,FALSE)=0,"",(VLOOKUP(I2,PURGE!I2:S1000,4,FALSE)))
as an ARRAY - that is when you use CTRL SHIFT ENTER to enter it and get it wrapped in {}. Array's are resource-intense and can start to slow your file down
1. $ is used to absolute a cell reference, locking it so that when copied, it doesnt change.. it comes in 3 different "flavors...
$A$1 absolutes the entire cell reference, it will not chance when copied down or across
$A1 absolutes only the column, "A" will not change when copied across, but "1" WILL change when copied down
A$1 absolutes only the row, "1" will not change when copied down, but "A" will change when copied across
So formulas like
=VLOOKUP(I2,PURGE!I2:S1000,2,FALSE)
need to be
=VLOOKUP($I2,PURGE!$I$2:$S$1000,2,FALSE)
otherwise, as you see, they change to this, when copied down...
=VLOOKUP(I3,PURGE!I3:S1001,2,FALSE)
Bookmarks