hi guys, I am a sort of newbie with excel.

I have 2 spreadsheets which I inherited from the previous IT manager.

1. master spreadsheet

2. Ref spreadsheet

within the master spreadsheet I have few columns, one of them represent
engine code.

within the ref spreadsheet I have a description of that code.

what I would like to do is to create a macro within the master spreadsheet
that will look for the value in the ref spreadsheet and will replace the
code with the value.

any idea ?