CODEWITHSUNDEEP
excel
Penbeuz
Penbeuz

Reputation: 168

How to use a calculated name in a formula

Is it possible to calculate a name to be used in a formula?

say I have this formula:

MATCH(C12;_PR.item;0)

I would like to compute the name from a string and a cell like the following that doesn't work

MATCH(C12;"_PR."&C1;0)

Upvotes: 0

Views: 56

Answers (1)

Jerry
Jerry

Reputation: 71598

Use INDIRECT:

=MATCH(C12;INDIRECT("_PR."&C1);0)

It takes a text string and converts it to a reference.

Upvotes: 1

Related Questions