Hi there. I'm making a little model to build up a cost based on a number of list ranges with look ups to a pricing database. I want to be able to look up whether a selection is valid based on a logic matrix that I have made. To do this, I have created a table in the following style:
Selection 1a | Selection 1b | Selection 2a | Selection 2b
Selection 1a X
Selection 1b X
Selection 2a X
Selection 2b X
In this example, I could have two drop down boxes to select option 1 a or b and option 2 a or b. Is there a way to run a lookup so when I make my selection, I check this array to see whether there are any conflicts between the selection I have just made, and the other current selection in my drop down boxes? In my real example I have around 20 selection fields, each with around 5 options so this needs to scale up to a large logic array. Thoughts? I could do it with a macro but I'd rather it run with formula run from the sheet if this is feasible?
Selection 1a | Selection 1b | Selection 2a | Selection 2b
Selection 1a X
Selection 1b X
Selection 2a X
Selection 2b X
In this example, I could have two drop down boxes to select option 1 a or b and option 2 a or b. Is there a way to run a lookup so when I make my selection, I check this array to see whether there are any conflicts between the selection I have just made, and the other current selection in my drop down boxes? In my real example I have around 20 selection fields, each with around 5 options so this needs to scale up to a large logic array. Thoughts? I could do it with a macro but I'd rather it run with formula run from the sheet if this is feasible?