Hello all, I'm stuck trying to figure out if this is even possible in excel. Basically what im trying to set up is a chart that will give me a yes or no answer. sounds simple enough but where i'm struggling is this. in cell A1 there will be a drop down list of all 50 states. same goes in cell B1. What i would like to do is show some states will show a yes or no for different state combinations, for example , California and Arizona would get a "yes", where as California and New York would get a "No" any ideas ?? Thanks