Quote Originally Posted by Jan Karel Pieterse View Post
Guess I misunderstood. But you can use the name my code creates to refer to the entire table and use e.g. INDEX(LocalTable,,2) to refer to the second column if that helps?

I need to refer entire row from A2:I2 for formula in K2 and autofill for the rest of the table.
(I know A2, but not the end range K2)