speeding up vlookup

[Guest]

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.

 

[Bob Phillips]

Lolly,

You could try putting the lookup array into a worksheet range, and use that
range in the formulas.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ken Wright]

Do you mean time wrt efficiency and speed of calculation, or speed of how
long it takes to download over the web.

Assuming you mean efficiency and speed of calculation, then can you sort
your data in Col A in Ascending order such that you don't need to use the
optional last argument of FALSE in your VLOOKUP statement. Either leave
Blank or use TRUE.