I have a drop-down list in cell A38. Based on the value selected there, I need a formula to pull data into cell K39. It needs to be something like: =IF($A38="January_2017",AM39,0), but I keep getting #VALUE errors. AM39 is a sentence and I've tried quotation marks and several other options. I would technically prefer that the value from A38 pull a whole range (there is a named range for January_2017 as well as it being the value for the list), but I would settle for individual formulas pulling in the specific cells I need. Thanks!
List value returns values from another named range
-
-
-
Re: List value returns values from another named range
I should probably specify that the issue seems to be when I'm nesting a bunch of dates. I need something like =(IF($A38="January_2017",AM39,0))+(IF($A38="February_2017,AN39,0)) and the error seems to occur with that + in there. I can return the proper value with the basic original formula from up above, but when I try to add the additional months, it gives the #VALUE error
-
Re: List value returns values from another named range
You have supplied a problem without a file. The 5 minute solution takes longer as people need to re create your problem.
Try and think of your problem from the other end, it makes life in forums easier for all.
Take care
Smallman
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!