Hi! I have a question about a formula entering data into a cell if it contains certain data.
example:
if cell G2 contains "AL", then J3 "Alabama Insurance Department"
I want a cell to know if it contains a state's abbreviation, to enter it's Insurance Department in another cell.
So...if G2 contains any other state abbreviation, the enter "__________ Insurance Department in J3.
Is this possible.
Thanks for any help.
Scott
example:
if cell G2 contains "AL", then J3 "Alabama Insurance Department"
I want a cell to know if it contains a state's abbreviation, to enter it's Insurance Department in another cell.
So...if G2 contains any other state abbreviation, the enter "__________ Insurance Department in J3.
Is this possible.
Thanks for any help.
Scott