Forum Discussion

Copper Contributor

May 21, 2023

Indirect with array of ref_text? I think it is possible!

Hi, I would like to start a discussion about the Indirect function with an array because I don't see much information about it when searching on the Internet. First, we all know that the formula =I...

excel

Formulas and Functions

office 365

Harun24HR

Bronze Contributor

May 21, 2023

For Office365 you can use BYROW() function then use INDIRECT() inside it.

milatr98

Copper Contributor

May 21, 2023

Harun24HR yes, but that could be another topic. If the "array" parameter is an array, it behaves the same with indirect + array. If you put a reference to cell/range in that parameter, it executes differently.