Ask Your Question
0

Insert all data of a named expression

asked 2017-11-07 07:44:52 +0200

carles99 gravatar image

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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-11-07 10:12:15 +0200

m.a.riosv gravatar image

updated 2017-11-07 10:13:12 +0200

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

What is an array formula

image description

edit flag offensive delete link more

Comments

If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2017-11-07 22:44:04 +0200 )edit
0

answered 2017-11-07 10:57:20 +0200

carles99 gravatar image

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

edit flag offensive delete link more

Comments

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

m.a.riosv gravatar imagem.a.riosv ( 2017-11-07 22:43:52 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-11-07 07:44:52 +0200

Seen: 22 times

Last updated: Nov 07 '17