Alan,

I do agree with you that arrayfunctions are great to perform some otherwise
impossible actions.
On the other hand however I regularly read that they do slow down
calculations, which is somewhat contradictionary to what the OP asks. Am
I wrong im my assumption to this item ?

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

"Alan Beban" wrote in message
...
You might want to consider something like

=VLOOKUP(lookup_value,lookup_table,{2,3,4,5,6},FAL SE) arrray entered
into a 5-column row of cells.

Alan Beban

Fred Smith wrote:

I'd like to speed up the execution of my macros. Does anyone have a tip
sheet on this?

In particular, I use a lot of Vlookups. In one case, I need five
adjacent
cells on a particular row. Currently, I use 5 Vlookups. Is there a way
to
get all 5 at once? And/or should I replace the Vlookups with something
else?

Thanks,
Fred
Please reply to newsgroup, not e-mail