Forum Discussion

ecahbra's avatar
ecahbra
Copper Contributor
May 29, 2021
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 th...
excel
Formulas and Functions
  • JMB17's avatar
    JMB17
    May 29, 2021
    Try: =INDIRECT("JanEmp"&ROW()-3)
JMB17's avatar
JMB17
Bronze Contributor
May 29, 2021
Try: =INDIRECT("JanEmp"&ROW()-3)
  • ecahbra's avatar
    ecahbra
    Copper Contributor
    May 29, 2021
    Thanks that is just what I was looking for. Works a treat!