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