Cheers everyone,
I am doing a translation and I am using Excel. There are two columns in my worksheet. Column A with the original text and column B with the translation. Every once in a while I run into a word I have translated before.
Is there anyway I could have excel checking if the value of cell A (x) is equal to a value A (1-x) (eg. A8) if so then fill cell B (x) with the corresponding value (eg. of the cell B8).
Perhaps it is a simple conditional formating but I can't figure out the formula.
Thank you.
D
Bookmarks