Forum Discussion
Using named ranges
Hi,
I have attached a sample file.
I have 2 named ranges: start and end.
If I use the names in a formula, data is selected from the same column.
I would like to reference a different column, for instance: start year 2001 = 2 * end year 2000.
How can I accomplish this using formulas with named ranges?
Hi chris15 ,
Let me know if this works for you:
You need to reference the cells in a different way, unfreezing the column. I mean, instead of $E$3 type E$3 and the formula will change every time you drag it.
If this solution fits your request, please mark as a best response to help others.
Regards!
Karchavez
3 Replies
Hi chris15 ,
Let me know if this works for you:
You need to reference the cells in a different way, unfreezing the column. I mean, instead of $E$3 type E$3 and the formula will change every time you drag it.
If this solution fits your request, please mark as a best response to help others.
Regards!
Karchavez
