Multiple Conditional Value Lists with a Looked-Up Value
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