Search and replace function

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.

the Vlookup function should work... put your english words in column C (C1-1000) u want translated. in column D put the formula =Vlookup(C1,A:B,2,FALSE). Also switch your A-B columns putting the english words into column A and the german words into B.

Keeps telling me the function is invalid and highlighting =Vlookup(C1,A:B,2,FALSE)

hmm can you upload a sample to show the error, the function in question is working on my computer

oh is the error an N/A error? that means that the english word was not found in your database. You can add a catch for that if you want...

=IF(ISNA(Vlookup(C1,A:B,2,FALSE)),"Not Found",Vlookup(C1,A:B,2,FALSE) )

here it is

http://imageguru.net/images/functitut.jpg

try the german version of Vlookup SVERWEIS instead

Is giving me the same error.

Work day is over, and I can't stay back today. Will have to take another look at it tomorrow

Still having trouble with this Vlookup/Sverweis function.. can anyone give me a hand? The code im trying to use now is:

=Vlookup(C1,A:B,2,FALSE) the equivalent =Sverweis(C1,A:B,2,FALSCH)

Still struggling

woo fixed it

thanks dontich