See your 2nd post for a formula where name & type are in the same cell.

Mike F
"Joe" wrote in message
...
i have columns that contain names of insurance companies followed by their
type. example
aetna grp
progressive pip
cigna wc

i would like to write a formula that would result in a 1, 2, or 3
corresponding to the type (grp, pip, wc)

i'm thinking the formula would read
'if this cell contains 'grp' = 1, 'pip'=2, 'wc'=3'

i cannot figure out how to write this formula

thanks MS group