Jun 12 2022 04:46 AM
=XLOOKUP(A2, INDEX7[SYMBOL], INDEX7[[INSTRUMENT]:[2013%]])
This is my formula. INDEX7 is the name of the table.
This works fine in a range. But when I convert the range to a table, it stops working (even though it fits the row). And I get a "#SPILL!" error.
Any idea what I can do alternatively?
Jun 12 2022 04:54 AM
@VarunAgw Indeed, you can not use dynamic array formulas inside a structured table. You need to write the formulas separately. One for each column or, as you already have discovered, work in a regular range.
Jun 12 2022 06:27 AM