Hello! I have a file I need to update with records from another excel file, where both files are thousand of entries long. Here's what I'm looking to do:
IF DOC1 cell B1 is an exact match for DOC2 cell A*, replace DOC1 B2 with contents of DOC2's Column C on the same line.
For example:
Let's say Document 1's cell B36 has text "PotaTo123" and that exact text (PotaTo123) is found in any cell in Document 2's column A (let's say A4), then the contents of Document 1's C36 should be replaced by the contents of B4.
Essentially, I have thousands of lines of text in a foreign language and a translation that must be updated with something more accurate (although not every translation is being updated).
What is the best way to handle this kind of project? Are there any utilities to handle this kind of thing? My skill with excel programming is extremely basic.
Thanks!
IF DOC1 cell B1 is an exact match for DOC2 cell A*, replace DOC1 B2 with contents of DOC2's Column C on the same line.
For example:
Let's say Document 1's cell B36 has text "PotaTo123" and that exact text (PotaTo123) is found in any cell in Document 2's column A (let's say A4), then the contents of Document 1's C36 should be replaced by the contents of B4.
Essentially, I have thousands of lines of text in a foreign language and a translation that must be updated with something more accurate (although not every translation is being updated).
What is the best way to handle this kind of project? Are there any utilities to handle this kind of thing? My skill with excel programming is extremely basic.
Thanks!
