Hello,

So the question is:

How do I tell excel to find a string of characters in a specific cell, that are in another cell somewhere in the vast massivness which is my document. Like finding duplicates. Then take the information from the cell neighbouring that in which the dublicate was found and displaying it in the cell neighbouring the cell from which the function was iniated.

For example, search for the string of text that is in the cell C1, throughout the rest of the document(kind of like a duplicate search), which perhaps is found in cell B125, then instead of taking the information from B125, take information from the cell neighbouring; A125, and pasting it in cell D1.

background information:

I'm compiling a list of translated words from English to German, the translations have been completed and are sitting next to the original word in the neighbouring coloumn. (Column A contains all the German words of the English equivalent, which are in column B)

I now have a mixed list of about half the English words, which I would like to get the German translations for. So without typing all the translation in separately, which will take forever, I wanted to tell excel to find this word (in my new list of english words), in Column B and then put the translation which is in Column A next to the word for which I require the translation.

Also, replacing the english word with the german translation would also be sufficient.