Insert all data of a named expression

[carles99]

Hi,
I defined a named expressión (NAMEDEX1) with some data below:

NAMEDEX1

data1

data2

data3

data4

What I want to do is call this named expression inside an IF function and if it is true, show all data from this named expression one below the other.
Is it possible?
Thanks in advance

[mariosv]

Introduce the IF like an array using [Ctrl+Chift+Enter] instead only [Enter]

What is an array formula

[mariosv]

If the answer solves your question please tick the .

[carles99]

Wow! Thank you very much!!! Muchas gracias!!!

[mariosv]

Please use the comments for that, this is not an answer.