Hi Morten, On Thu, May 26, 2011 at 11:13:11AM -0400, Morten Welinder wrote: > Use IFERROR.
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. Thanks, Mark -- The more things change, the more they stay the same. _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
