Wildcard and Nested IF Statements

[madkinson]

In Excel 2013, I'm trying to create a nested IF statement using wildcards. I have data similar to the following:

PC Unit Account
CMCPX 21002400 GOOD
CMOPX 21002400 BAD
CMOPX 70021160 GOOD
CMCPX 70021178 BAD
CMOPX 70021186 GOOD
CMCPX 21001599 GOOD
CMOPX 21003601 BAD

When "PC Unit" = "CMCPX", I want the 3rd column to say "Good" whenever "Account" (col B) is equal to "2100*"
When "PC Unit" = "CMOPX", I want the 3rd column to say "Good" whenever "Account" is equal to "7002*"
Any other combination of values should be marked as "Bad".
There can only be either one of the other listed values in col A.
Since there are multiple valid ACCOUNT values, I tried to use a"*" as a wildcard.

Try as I might, I cannot get a valid IF statement to work. I thought about using an INDEX/MATCH, but I don't know how to put the values into the INDEX. I've always referred to ranges instead.

I really would appreciate some assistance on this as the spreadsheet has about 55,000 rows and manually spotting bad values takes a REALLY long time.

Thanking you in advance,
Mark

 

[igold]

@mark, thanks for the feedback.

@ron, no need to dwell on this, the OP got it going. We can leave it at gremlins.