Hey everyone,
Looking for some help again. I have a formula..... =IFERROR(IF($G$8="Primary",VLOOKUP(I$8,INDIRECT("PrimaryDailyRange"),2,0),IF($G$8="Secondary",VLOOKUP(I$8,INDIRECT("SecondaryDailyRange"),2,0))),0),
that works exactly how I need it to in one worksheet. The next worksheet is almost exactly the same as the first, except I am getting the data from a different named range. I am trying to use this same formula with the new named range, but it returns 0 instead of the data in the referenced cell. =IFERROR(IF($G$8="Primary",VLOOKUP(U$8,INDIRECT("PrimaryWeeklyRange"),2,0),IF($G$8="Secondary",VLOOKUP(U$8,INDIRECT("SecondaryWeeklyRange"),2,0))),0)
What am I doing wrong? I don't understand why it works for one named range and not for the other.
Any ideas?
Thanks all.
Looking for some help again. I have a formula..... =IFERROR(IF($G$8="Primary",VLOOKUP(I$8,INDIRECT("PrimaryDailyRange"),2,0),IF($G$8="Secondary",VLOOKUP(I$8,INDIRECT("SecondaryDailyRange"),2,0))),0),
that works exactly how I need it to in one worksheet. The next worksheet is almost exactly the same as the first, except I am getting the data from a different named range. I am trying to use this same formula with the new named range, but it returns 0 instead of the data in the referenced cell. =IFERROR(IF($G$8="Primary",VLOOKUP(U$8,INDIRECT("PrimaryWeeklyRange"),2,0),IF($G$8="Secondary",VLOOKUP(U$8,INDIRECT("SecondaryWeeklyRange"),2,0))),0)
What am I doing wrong? I don't understand why it works for one named range and not for the other.
Any ideas?
Thanks all.
Attachments

79 KB Views: 2

136 KB Views: 2

52.5 KB Views: 4

161.1 KB Views: 3