Build formulas based on matrix

2.50K viewsFormulas and Functions
0

is it possible to build a formula based on the contents of a matrix??

ie

Matrix input

Matrix 1 Item 1 = input [target matrix name]
Matrix 1 Item 2 = input [target Item]

Formula

Matrix 2 formula = [target matrix name]::[target Item]

0

You would have to use an INDIRECT function to do this.