I have two sheets in my excel book. On the first sheet (starts from M3 ends M33000) I have list of abbreviations which are randomly listed and used more than one times. On the second sheet I have the list of abbreviations (starts from A2 ends A22000) used in the first sheet, these are listed as an index I have long forms of these abbreviations in the next column (B3 to B22000).
What I am trying to do is to call the long form of abbreviations listed on sheet 2 to the right column of the abbreviations used in the sheet 1 ?
I have tried different formulas, yet I could not manage to solve it. I would like to ask you whether this is possible and any of you have an idea?