Ask Your Question

How to use cell value as a row number in referencing?

asked 2015-05-07 04:31:14 +0200

timinzee-doe gravatar image

updated 2015-08-27 20:39:14 +0200

Alex Kemp gravatar image

Hi, I'm using libreoffice 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!

edit retag flag offensive close merge delete


About sort, take a look to the option: Menu/Tools/LibreOffice calc/General - Update references when sorting range of cell.

m.a.riosv gravatar imagem.a.riosv ( 2015-05-07 09:59:00 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-05-07 08:05:14 +0200

karolus gravatar image

Some Formula-(-mess) like:


the same with



edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-05-07 04:31:14 +0200

Seen: 4,356 times

Last updated: May 07 '15