Forum Discussion
Formula Help
Hi All, I hope that someone can help with a formula i am trying to do. I have attached a visual explanation of the formula so far and what I want to additionally calculate. Below is the formula curr...
If initial formula works, you may add to it
+LOOKUP(level, Sheet3ItemLevel, Sheet3LevelValue)Thank you for your quick response.
The thing is I only want the level to calculate if column named ‘A’ or ‘C’ have markers. if either do then it can lookup level and add corresponding value.
Hope that makes sense?
Many thanks
With this you may add with lookup under the main formula condition where you check for the marker.
