Forum Discussion
Solved
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)
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).