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 _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
