In a data entry worksheet, I want to ensure that users select a certain
'category' for all expenses. I am using a validation list (with dropdown)
for the Category. I then created this IF statement to check whether the user
selected the right category for the expense. Unfortunately, my IF statement
always results in FALSE, even when the Category is correct. Is it even
possible to use IF statements with a validation list? My formula works great
if I check a cell that does not use the validation list. Any thoughts?