Replacing words in paragraphs within cells IF it meets all criteria described

[alexenposadas]

Cell A1 contains a paragraph made of Hebrew words (They are Bible verses in Hebrew, so sometimes more than 254 characters long in each cell).
Cell B1 contains a paragraph of English words (They are Bible verses in English, so sometimes more than 254 characters long in each cell).
Column C contains a list of single Hebrew words.
Column D contains a unique code for each of those Hebrew words.
Column E contains a list of single English words.
Column F contains a unique code for each of those English words.
Finally, Column G contains a list of single words that will be replacing the English words IF all criteria is met.

So, this is what I'm trying to do:
IF a Hebrew word within the paragraph of cell A1, is the same as a Hebrew word found in the list in Column C,
AND an English word within the paragraph of cell B1, is the same as an English word found in the list in Column E.
AND the unique code for this word is the same in (both) Column D and Column F,
THEN create a new paragraph (Bible verse) in a (new) Column H, which will be a combination: Rendering the existing English words from B1 that did not meet this criteria, but rendering the transliterated words from Column G when all criteria is met.
I'm not sure Excel will support this task because of the 254 character issue, but since I don't know VBA, I figure getting help in Excel will be easier.


Thank you kindly,
Alex

 

[Matt Rogers]

Hi Alex,

Could you give some examples?

 

[alexenposadas]

Hi Matt, I have an Excel sample file to provide but I don't see how to upload files. Is there a way?

 

[Matt Rogers]

Hi Alex,

To post a screenshot: Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste