If and COUNTIF formulas

[nealoconnor]

code in Column Group associated w/data
WRXLAA 412
W8CCAA 412
WRASAA 411
WZ5EAA 411
WVPYAA 302
WRDSAA 302
WR8UAA 926
WVPWAA 926
WSKYAA 411
WZTSAA 411
WRU1AA 302

I need a formula that will sort the code in column by it's first 4 places (WRXL*) and label by the cooresponding groups. I have 30+ codes per group but need a working formula to input them into. Below is what I was trying to develop for one group, then insert the others into the false variable so it could sort and label all codes.

=IF((COUNTIF(F3,{"WRXL*","W8CC*","WRAS*","WZ5E*","WVPY*","WSP5*","WTFS*","WSPX*","WR0F*","WZ4W*","WQ8B*","WZ4S*","WZ4V*","WRAT*","WRAR*","WRAW*","WRAY*","WQ5U*","WR84*","WR85*","WRDU*","WRDV*","WQ6U*"}))>=1,"412"," ")

This formula only recognizes the first code "WRXL*" then stops. I'm self-taught and need some SME help!

[RobertMika]

Check this
search.xlsx

but you can as well create a Name Range from your criteris and refer that in this formula.