I have a formula I'm trying to construct which will look at a cell and then search for a term in another cell based on what populates the first cell. If there isn't a match between the two a message will display saying, "Verify Selections". Instead of displaying the message, False is the only displayed text.
For the formula, displaying nothing means the combination of the two choices match and no further action is required, and the message is only displayed when the two selected options do not match.
I have many data validation cells that piggy back off the previous and I would like to create a warning if the series of selected cells do not match as they should.
It will work correctly in some combinations, but not all.
Sample workbook attached.
Bookmarks