Last answered:

02 Oct 2023

Posted on:

22 Aug 2023

0

Resolved: We can just use Q_1 in the formula instead of indirect function. So why using Indirect function?

We can just use Q_x (x=1, 2,3). 


I mean : =Vlookup(B25;Q_1;2;FALSE)

Instead of : =Vlookup(B25;INDIRECT(C24);2;FALSE)


So I was wondering what is the added value of using indirect fonction in the formula?


Thank you in advance.

3 answers ( 1 marked as helpful)
Instructor
Posted on:

16 Sept 2023

1

Hi rajaonarivony!

Thanks for reaching out.

Named ranges help you organize the data of your sheet in an efficient way. 

Then, sometimes in computations we need to refer to many cells and, analytically speaking, it might become harder to trace where the numbers used in the formulas come from. In that case, INDIRECT() gives you a good indication on where are some of the values in a formula derived from.

Also, and more importantly, if you want to apply the same formula for several sets/subselections of data in your sheet, instead of changing the entire formula for each subselection, you can just change a referenced cell in it.

Hope this helps.
Best,
Martin

Posted on:

18 Sept 2023

0

Clever

Thank you!!

Instructor
Posted on:

02 Oct 2023

0

You are very welcome!
Kind regards,
Martin

Submit an answer