Hi all,
I have created an excel workbook, and now I want to tell the users of this
workbook, that some combinations are not valid. E.g. A car is in 3 models,
1000 cc, 1500 cc and 2000 cc, and for this car is available in 4 colors,
except for the 1500 cc model, there the available colors are reduced to 1
color.
The models are in a separate sheet listed, a vlookup is checking the models
and the available color. I need to have a sort of popup screen displaying
that for model 1500 cc, which in the extra sheet is listed as not available,
the combination with that color is not applicable.
thx
Gerard