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?

Correction, If there is no matching value in the conversion table, it should leave the original value as-is

Hello,

Please find working example in attached file.

My solution is

Please Login or Register  to view this content.

Best Regards
MaczaQ

try this and if so, mark the thread as SOLVED

Please Login or Register  to view this content.

hi, davekippen, please check attachment, run code "test"