Re: [libreoffice-users] split a huge table in subtables (say on different sheets) and link some columns between these tables???

> > > "RG" == Remy Gauthier <remygauthier@yahoo.com> writes:

> Hi,
> You can use the SUMIF function to have the ResSh1 and ResSh2 of final
> to be updated each time you make an entry. If you only have one "Smith"
> per table, you can use VLOOKUP to fetch the $7 value for Smith. You
> will use these functions to find the "Smith" values in each of your
> smaller tables.

> Assuming "Name" of table1 is in A1, "Smith" of final is in A2, and
> there are 20 rows in table1, using SUMIF for the ResSh1 in final would
> bring:

> =SUMIF(table1.$a$1:$a:20,CONCATENATE("=",final.a2),table1.$g$1:$g$20)

> For ResSh2, you will replace table1 with table2.

> If you want to use VLOOKUP, then you will have, for final.ResSh1:

> =VLOOKUP(final.a2,table1.$a$1:$g$20,7,FALSE())

> I hope this helps.
> Rémy.


Thanks very much I will have a look. That might be the most elegant
solution so far.


-- 
Warning: Content may be disturbing to some audiences
I strongly condemn Putin's war of aggression against Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the NATO membership of Ukraine.
I support the EU membership of Ukraine. 
https://addons.thunderbird.net/en-US/thunderbird/addon/gmail-conversation-view/

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy