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

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 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 You'll want to use the INDIRECT function that converts a string to a formula, that is: =INDIRECT("Setup.$C"&E3)

more

Thanks! Never heard of INDIRECT until now.

more

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)

more