Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 07 May 2015 04:31:14 +0200How to use cell value as a row number in referencing?https://ask.libreoffice.org/en/question/50346/how-to-use-cell-value-as-a-row-number-in-referencing/Hi, I'm using libreoffice 4.2.8.2 on Lubuntu 14.04.
Ok, so I have 3 columns: A, B, and C. I have integers in B, and any info in C. Say I have row x in A, I want to point to row x in B, which contains the value of y, in such a way that row x of A displays the value of row y in C. I want to do this correspondingly with all rows in A.
Can I do it? Ultimately I want to be able to sort different columns that refer to each other without messing up the references. When I just directly reference a column / row, sorting messes things up.
Thanks in advance!timinzee-doeThu, 07 May 2015 04:31:14 +0200https://ask.libreoffice.org/en/question/50346/