Hi Pete

Post your formula

--
Regards

Roger Govier


"Pete" wrote in message
...
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?