Re: Lookups across multiple sheets

Hi Oliver,

On Fri, May 27, 2011 at 07:54:48AM +0100, Oliver Burnett-Hall wrote:
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

They are seperate datasets that need to be maintained seperately. They
grow over time, I need room on each sheet to expand them downwards
for an unknown amount of lines. So it made sense to put them on
different sheets.

I read some article about this problem in excel where they did something
with array formula's and lookups. The formula was:


where C2 contains the value to be found and MySheets is name pointing to
a range with the names of the sheets. But it wasn't something I could
get working in gnumeric.

The more things change, the more they stay the same.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]