Match word and Add to next column
Hi all,
One of the managers in my company came out with something that he wants to be done in Excel. It goes like this.
He has an Excel file that contains a list of some English words in one column and its translation into Arabic in the next column. This data is in Sheet1. In the rest of the sheets in the same Workbook, he types in these words in one of the columns of these sheets and he wants the corresponding arabic word to be placed automatically. This action can take place either on the click of a button or....nothing comes into my mind. Can anybody please help me on how this can be done?
Thanks.