Re: Lookups across multiple sheets



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]