Hi, I have been trying to give some values to a column comparing another column with a table on another excel file. Example:
This two are the original excel files:


This is what i am looking forward to have.

I have been watching tutorials and lots of themes here and i cannot finde anything.
Could anyone help me?
Thanks!!