IF(Left(B1,2)="CR", your results

Not sure what P is.. P1?

Then, P1="HQ",P1="OC")

"ttp" wrote:

I'm trying to create a simple filter to return a specific text statement if
the variable begins with 'CR'. EXCEL is returning false when I believe the
statement is true. Please help me see my error.

If(B1 = "CR*), then P = HQ else P = OC