Ask Your Question
0

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

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

timinzee-doe gravatar image

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

Alex Kemp gravatar image

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!

edit retag flag offensive close merge delete

Comments

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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

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

karolus gravatar image

Some Formula-(-mess) like:

=INDIRECT("C"&A1)

the same with

=OFFSET($C$1;A1-1;0)

or

=INDEX(C$1:C$1000;A1)
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 2,548 times

Last updated: May 07 '15