If statement with validation list
 

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?

If statement with validation list
 

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?

If statement with validation list
 

My cells a

A B C
Category Expense Check

Administration $- formula here
Full PRT Solution Development $- formula here
Full PRT Solution Development $- formula here
Product Development 4.5 $350.00 formula here

My formula is:

=IF(b10,IF(a1="Travel",,"Category Must Be Travel"),"OK")

"Pete" wrote:

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?

If statement with validation list
 

=IF(AND(B10,OR(A1={"Travel","Category Must Be Travel"})),"OK"," Not OK")

"Pete" wrote:

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?

If statement with validation list
 

Maybe I should simplify it, take it one formula at a time.
Cell a1 = my category list, validation with dropdown.

My statement = IF(a1="Travel","OK","Not OK")
returns "FALSE" even if cell a1 = Travel.

"Teethless mama" wrote:

=IF(AND(B10,OR(A1={"Travel","Category Must Be Travel"})),"OK"," Not OK")

"Pete" wrote:

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?

If statement with validation list
 

ok, it seems that my IF statement will not work if the formula references a
cell that contains the validation list. Oye vey ....

"Pete" wrote:

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?

If statement with validation list
 

If you may have leading or trailing space that will cause the problem.
This formula will remove leading/trailing spaces

=IF(TRIM(A1)="Travel","OK","Not OK")


"Pete" wrote:

ok, it seems that my IF statement will not work if the formula references a
cell that contains the validation list. Oye vey ....

"Pete" wrote:

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?

If statement with validation list
 

That did it, YOU ROK Teethless Mama.
Happy New Year!!!

"Teethless mama" wrote:

If you may have leading or trailing space that will cause the problem.
This formula will remove leading/trailing spaces

=IF(TRIM(A1)="Travel","OK","Not OK")


"Pete" wrote:

ok, it seems that my IF statement will not work if the formula references a
cell that contains the validation list. Oye vey ....

"Pete" wrote:

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?