CODEWITHSUNDEEP
excelexcel-formula
JRob23123
JRob23123

Reputation: 27

Excel: Get cell value by referencing text of another cell (without using VBA)

I have this situation.

A1="Text I want" (A1 is the text i want)

X1="A1" (X1 is the cell of the text i want)

I now want Z1 to be the text of A1 using the reference provided by X1.

Ex: Z1=gettextofthiscell(X1)==>getvalueofthiscell(A1)=="Text I want"

What formula for Z1 would do something like this (without using VBA)?

Thank you.

Upvotes: 1

Views: 1622

Answers (2)

Nowakowa
Nowakowa

Reputation: 63

I believe you are looking for Indirect function: Z1=Indirect(X1)

Upvotes: 2

Foxfire And Burns And Burns
Foxfire And Burns And Burns

Reputation: 12008

You need to use INDIRECT

INDIRECT function

Insert this function in Z1. The argument must be X1. Of course, X1 value must be A1. Then the formula will read XI and get get the text of A1.

=INDIRECT(X1)

An example:

enter image description here

Upvotes: 3

Related Questions