Home / Questions / 32218
Accepted
Goerman
Asked: 2020-11-07 18:59:48 +0800 CST 2020-11-07 18:59:48 +0800 CST

How to get the value of a cell by concatenating row and column in a Google spreadsheet?

  • 772

If there is "some value" in cell F1, it is required to obtain that data as a concatenation of cells B3 and B4, where B3="F" and B4="1".

attempt :

Use the & operator to perform concatenation.

="="&B3&B4

Resulting in "=F1" as a string plus not the data located in said cell.

google-hoja-de-cálculo

1 Answers

  1. Best Answer

    Short answer

    Try INDIRECT

    Explanation

    INDIRECT converts a string in either A1 or R1C1 notation to a reference.

    In this case the formula would be as follows

    =INDIRECTO(B3&B4)

    Note that the operator =is only included once, and this is done at the beginning of the formula.

    • 2