I’m looking for a way to AutoFill cells based upon previous filled cells.

I have this formula in a cell

I’m creating a database. Column A contains different elements. Column B is a “.type” column, so I need to assign one number to each of those elements and that number needs to be consistent across the whole database, as follows: