Re: A way to optimize this funktion?

[bhoel despammed com (Berthold Höllmann)]

"Morten Welinder" <mwelinder gmail com> writes:

> You can do two things:
>
> 1. Make sure you are using a very new Gnumeric.  Collections of
> vlookup/hlookup/match with common data area got *much* faster.
> The lookup type where the database is not sorted easily got 3-4
> orders of magnitude faster for the second and later calls.
>
> 2. Use index, not indirect.  That's true for 99%+ of all uses of
> indirect.

Thanks for the tips.

> Morten

-- 
A: Weil es die Lesbarkeit des Textes verschlechtert.
F: Warum ist TOFU so schlimm?
A: TOFU
F: Was ist das größte Ärgernis im Usenet?

Attachment: pgpmWMrT2hIae.pgp
Description: PGP signature