View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default VlookUP Multiple tables

Believe me Max ... you wouldn't be saying that if you were responsible for
keeping a plant going which depended on using several 30 to 40 K row WBs,
which also have in excess of 150 columns.

Of course, they didn't start out that big, but after being exposed to the
problems (calc & re-calc & opening times) involved with *large* files, one
automatically becomes a miser where freely spending "resources" is
concerned.
Even using the "wrong" type of error checking (dbl and triple vlookups)
becomes very "expensive".

Volatiles just add to the nails in the coffin.<g

I'm *very* gun-shy when it comes to using them.
And, of course, I'm *not* talking about a 2 sheet, 100 row production
report.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Max" wrote in message
...
Notice how "volatile" this thread has become ? That's the spirit <g
(It's pretty quiet elsewhere, especially wrt feedback from OPs to

responders
.. just rough-count how many posts where OPs respond to responders ..)

Anyway ... up, up, up with ALL volatile functions !! <bg
(just a clarion call not to shy away from using these, that is)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---