K
KarenF
I have a simple IF stmt that I can't get to recognize wild cards.
=IF(X1="Food*","yes","no")
I want it to return a yes for Food, Food Dept, Food Services - Intl, etc.
In short, anything that starts with food. Shouldn't it be easy?
I have a macro that imports from another spreadsheet. Once I get a formula
to work, I record that step then paste it to my macro and adjust the code so
it compiles, then add steps to copy the formula to the rest of the rows.
Which is why I can't simply filter on "contains food."
If I can get this simple function to work then I'm confident I can apply it
to my complex formula. But, did I read somewhere that IF stmts don't support
wild cards?
KarenF
=IF(X1="Food*","yes","no")
I want it to return a yes for Food, Food Dept, Food Services - Intl, etc.
In short, anything that starts with food. Shouldn't it be easy?
I have a macro that imports from another spreadsheet. Once I get a formula
to work, I record that step then paste it to my macro and adjust the code so
it compiles, then add steps to copy the formula to the rest of the rows.
Which is why I can't simply filter on "contains food."
If I can get this simple function to work then I'm confident I can apply it
to my complex formula. But, did I read somewhere that IF stmts don't support
wild cards?
KarenF