Ask Your Question
0

[solved] Insert value from cell into formula [closed]

asked 2012-10-15 14:21:16 +0200

matthijs gravatar image

updated 2012-10-15 22:04:02 +0200

I'm puzzling with the following question.

I'm pointing to the cell Setup.$C3. However, the 3 should be a value from another cell (in row E (same sheet, not setup), like 3,4,5,6 et cetera). Just tried several options like:

setup.c&(E3)

setup.c&"E3"

et cetera.

How can i use a value from row E into a formule and combine it?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 16:11:37.775723

3 Answers

Sort by » oldest newest most voted
1

answered 2012-10-15 16:53:43 +0200

w_whalley gravatar image

You'll want to use the INDIRECT function that converts a string to a formula, that is:

=INDIRECT("Setup.$C"&E3)
edit flag offensive delete link more
0

answered 2012-10-16 00:25:39 +0200

m.a.riosv gravatar image

This works fine. But if you change the sheet name or insert/delete a column in A or B or both, the formula is not adjusted.

There are other options to do the job (see details and samples in the LibreOffice help):

INDEX returns a sub range, specified by row and column number, or an optional range index. Depending on context, INDEX returns a reference or content. Syntax INDEX(Reference; Row; Column; Range)

OFFSET returns the value of a cell offset by a certain number of rows and columns from a given reference point. Syntax OFFSET(Reference; Rows; Columns; Height; Width)

edit flag offensive delete link more
0

answered 2012-10-15 21:59:31 +0200

matthijs gravatar image

Thanks! Never heard of INDIRECT until now.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-10-15 14:21:16 +0200

Seen: 17,256 times

Last updated: Oct 16 '12