spotlitekid
New Member
- Joined
- Dec 12, 2013
- Messages
- 5
When i do a drop down Data list, and I create a formula in the name range, it always puts the current worksheet name in the formula. So every new month I have to create a new name range formula. How can I tell the name range formula to always look in the current sheet. Here is my formula:
=IF('Dec 2013'!IV11="CU",Stones.xlsx!cus,IF('Dec 2013'!IV11="EL",Stones.xlsx!els,IF('Dec 2013'!IV11="VE",Stones.xlsx!ves,IF('Dec 2013'!IV11="CO",Stones.xlsx!cos,IF('Dec 2013'!IV11="NA",Stones.xlsx!nas,IF('Dec 2013'!IV11="OW",Stones.xlsx!ows))))))
If i take out Dec 2013, it puts it right back in!
Thank you
Mitch
=IF('Dec 2013'!IV11="CU",Stones.xlsx!cus,IF('Dec 2013'!IV11="EL",Stones.xlsx!els,IF('Dec 2013'!IV11="VE",Stones.xlsx!ves,IF('Dec 2013'!IV11="CO",Stones.xlsx!cos,IF('Dec 2013'!IV11="NA",Stones.xlsx!nas,IF('Dec 2013'!IV11="OW",Stones.xlsx!ows))))))
If i take out Dec 2013, it puts it right back in!
Thank you
Mitch