Posted to microsoft.public.excel.programming

Lolly[_2_] Lolly[_2_] is offline

external usenet poster

Posts: 28

speeding up vlookup

Hi
I have used following Vlookup formula:
=VLOOKUP($A25, $A$435:$AR$535, {6,9,12,15,18,21,24,27,30,33,36,39}, FALSE)
This formula is used several times may be in 250rows.

Time taken to download the spreadsheet is 50seconds. Could anyone help me to
reduce the time taken by spreadsheet . This is because of Vlookup function.

Any help would be appreciated.
Thanx in advance.
--
Kittie

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Speeding up Excel calculations	JP Ronse	Excel Worksheet Functions	11	March 1st 10 03:23 PM
Speeding up calculations	sb1920alk	Excel Discussion (Misc queries)	10	October 10th 06 09:46 PM
Speeding Up A Spreadsheet	SamuelT	Excel Discussion (Misc queries)	2	June 16th 06 10:04 PM
Speeding up writes to cells?	Bruce E. Stemplewski	Excel Programming	7	January 30th 05 11:59 PM
speeding up a macro	Brenda[_5_]	Excel Programming	4	August 21st 03 12:56 AM

All times are GMT +1. The time now is 12:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us