Re: Lookups across multiple sheets
- From: Mark Verboom <mark verboom net>
- To: Morten Welinder <mortenw gnome org>
- Cc: gnumeric-list gnome org
- Subject: Re: Lookups across multiple sheets
- Date: Thu, 26 May 2011 17:25:40 +0200
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.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]