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)
Use INDIRECT
:
=MATCH(C12;INDIRECT("_PR."&C1);0)
It takes a text string and converts it to a reference.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments