1 2 Previous Next 21 Replies Latest reply on Mar 20, 2015 8:50 AM by philmodjunk

    Multiple Conditional Value Lists with a Looked-Up Value

    DanielPerry

      Title

      Multiple Conditional Value Lists with a Looked-Up Value

      Post

      Working on an estimating Database.
      I have imported a suppliers price list.
      Created 4 layers of conditional formatting to drill down to the particular item required.
      Then added a Look-Up to display the price for the item drilled down to.
      Problem I have is the look-up will display the first price from the item selected in to the first layer of conditional formatting, rather than the final item price once all 4 layers of conditional formatting is complete.
      Guessing I have made some form of rookie mistake here?
      Thanks in advance
      Dan

      Screen_Shot_2015-03-12_at_14.38.19.png

        1 2 Previous Next