# reference matrix name in a formula

If ColumnA contains Matrix names, how to reference the matrix with that name in ColumnB in a formula?

ColumnB = ColumnA::rows 1

Similar to using @ for Category names

Problem: for now I have 10 matrices to combine some of their elements into one matrix

Hi Bristly, I think I found a solution for you. As you see on the screenshot I used indirect function to make a matrix name variable. You do not need to change this formula when you add a new ticker, it works automatically when you add a new ticker item. Hope I could help you.

In fact, all I need is indirect(@F&”::Column 14″) to get the one item I need out each @F matrix. Without indirect() the variable matrix name is interpreted as text.

I am glad that I could help you. Good luck with your Quantrix models!

This is exactly what I was looking for. It works. Thank you.

My difficulty was not the syntax of the matrix name call as I thought but how it was being used; indirect() solves the actual problem.