Lets's see did I understood this:
You had a sheet in your workbook, with some table on sheet with some entries in column B. In same table, you had 3 different columns (A, D, and C) which contained category information about entry in same row.
Was there always a single category entered for entry into one of 3 category columns (leaving cells in other columns empty), or could an entry have up to 3 different categories?

Now you added another sheet and table, with copy of entry column B of earlier table in column B of new table. And you want category info from earlier table displayed in column left of column B in new table (obviousluy in column A of new table).

Now when in earlier table for every entry is only one category (or none), it will be easy. E.g. into cell A2 in new table you enter the formula like
, and copy it down.

When there may be several different categories in previous table for same entry, you have either make some decision the category from which column you prefer {e.g. implementing nested IF()'s}, or you have to redesign your new table so it will have a row to every different category entered into earlier table for this entry. And you have to implement more complex formula into new table and probably some helper column(s) like row numbering into older table!

The 3rd option is - I didn't understood anything