On Thu, 26 May 2011 17:25:40 +0200 Mark Verboom <[email protected]> wrote:
> IFERROR helps a lot, thanks! The only grief I keep with this solution > is when adding a sheet to the set. I saw some example about 3D > references with the SUM function (like sum(sheet1:sheet5!A1:A100)), > but they don't seem to work for the lookup functions. > > Is there any way to consolidate this type of reference? I am going to > use a lot of these, so it would really help in maintainablity. No, VLOOKUP and its friends only work with a single range. Why are you putting the source data into multiple sheets? Is it possible to revisit your design so that this data all goes into a single location? - olly _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
