Forum Discussion
fonction indirect dans le gestionnaire de nom
Bonjour,
Peut on utiliser la fonction indirect dans le gestionnaire de nom ?
Merci d'avance :-)
I think OFFSET is more relevant to your task.
It should also be possible to use the non-volatile INDEX to create the dynamic ranges you require
= INDEX(Range, 1, column_number) : INDEX(Range, final_row, column_number)
6 Replies
Yes.
I used a Name "CompanyData" which referred to
=INDIRECT(address)
The Named cell "address" contained the names of Ranges I wished to return.
Oui.
J'ai utilisé un nom "CompanyData" qui fait référence à
= INDIRECT (adresse)
"Adresse" de la cellule nommée contenait les noms des plages que je souhaitais retourner.Hi Peter,
Thansk for your answer.
Actually, I would like to use the function Inside the box.
Without knowing you intended use for the formula, I cannot be sure it is what you want. However, the name 'CompanyData' refers to
=INDIRECT(address)
The cell 'address' uses validation to ensure the user picks one of a selection of ranges (that may be on different sheets).
