Hello to you all,

I am a beginner when it comes to Excel and going through the already posted threads I did not find my answer so here I am.
I am doing my inventory and will be scanning bar codes that will be input in my excel document. But these bar codes are not the one in use on my software and once they are in my sheet I need to replace them all with the ones in use.
I have already a table with a column of the codes I want to appear versus the ones that come up when I scan the Item :
Screenshot (2).png
In a new sheet where I will be scanning items that will show with the code on column B, how can I replace them all with the same line from column A? Is there a way I can tell Sheets to use my two column sheet as a reference?

I really appreciate your help here folks, have a great one