Re: A way to optimize this funktion?

["Morten Welinder" <mwelinder gmail com>]

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.

Morten