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

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)


"Lolly" wrote in message
...
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

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.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Lolly" wrote in message
...
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