A way to optimize this funktion?

I have a sheet which provides an overview of the other
sheets in the
file. It uses lots of the following formula:

if(vlookup($A265;'other sheet'!$C:$C;1;false();true())<0;
   "";
   cell("contents";
        indirect(concatenate("'other sheet'!A";
                             vlookup($A265;'other
sheet'!$C:$C;1;false();true())+1))))

First I guess the double use of the
"vlookup($A265;'other
sheet'!$C:$C;1;false();true())" must be quite
inefficient. Is there a
was to reuse the result of the first "vlookup"
call? 

Second I im interested in the values of columns A and B of
the other
sheets. Is there a was to concanate the results of the two
cells into
one string using a format for the overview sheet?

Kind regards
Berthold
-- 
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?

_______________________________________________
gnumeric-list mailing list
gnumeric-listgnome.org

http://mail.gnome.org/mailman/listinfo/gnumeric-list

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
gnumeric-listgnome.org

http://mail.gnome.org/mailman/listinfo/gnumeric-list

"Morten Welinder" <mwelindergmail.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?

_______________________________________________
gnumeric-list mailing list
gnumeric-listgnome.org

http://mail.gnome.org/mailman/listinfo/gnumeric-list