Code to loop through a column and change cell value based on list

See attachment. Column B has values that need to be updated based on a list of conversion data. I need code to loop through column B, search that value against a table on the conversion list tab, and update each cell to the new value. if the value in column B does not have a match in the list, return "-"

Can be done?