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