LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Offset vs vlookup functions

I have a 20mb file that is using a whole series of vlookup functions. It is
quite slow in calculating. Does anyone know whether the calculation would be
quicker or slower if I switched them to an offset function?

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
index and offset functions Denise Excel Worksheet Functions 8 February 2nd 08 05:05 AM
Nested IF Functions with OFFSET [email protected] Excel Worksheet Functions 3 July 12th 07 04:18 PM
offset() with row() and col() functions? Zilla[_2_] Excel Worksheet Functions 2 March 2nd 07 01:23 PM
Trying to use sumif and offset functions hizzle Excel Discussion (Misc queries) 5 February 9th 06 11:47 PM
Offset and Indirect functions Thrava Excel Discussion (Misc queries) 4 December 23rd 04 05:07 PM


All times are GMT +1. The time now is 09:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"