Forum Discussion
Solved
using a formula to assemble named range name
Can you use a formula to assemble a named range name? In other words if you have 20 named ranges JanEmp1 through JanEmp20 can you use the row function to concatenate "JanEmp" and row()-3 to create the named range name to use in a formula?
- Try: =INDIRECT("JanEmp"&ROW()-3)
