A way to optimize this funktion?

[bhoel despammed com (Berthold Höllmann)]

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?