How to use the explicit "written" values from cells as a reference in a formula?

Question

Say in an Excel spreadsheet I have:

in column D, row 13: the number 12
in column D, row 14: the character E, and
in column E, row 12: the string Hello World.

In another cell, how can I combine the value from column D, row 13 (12) and column D, row 14 (E) such that I would get something like "=E12" which would be evaluated to Hello World.?

score 1 · Answer 1 · answered Mar 24 '15 at 21:38

1

Please try:

=INDIRECT(D14&D13)

answered Mar 24 '15 at 21:38

pnuts

58,317
11
87
139

score 1 · Answer 2 · answered Mar 24 '15 at 21:38

1

This should work.

=INDIRECT(CONCATENATE(D14,D13))

answered Mar 24 '15 at 21:38

tospig

7,762
14
40
79

@TMOTTM, yes, as pnuts used in his method – tospig Mar 24 '15 at 21:41

How to use the explicit "written" values from cells as a reference in a formula?

2 Answers2