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!
Don’t have an account yet? Register yourself now and be a part of our community!