blazy
Member
Hey chandoo,
I have one problem. Everything it is mentioned in attached excel file, I think this will be an easy one for you.
I have sheet one that shows the word in Arabic in first column and its Transliteration in second column.
Sheet two has The Arabic title in first column and would like column 2 to have a FUNCTION that will generate the English Transliteration by using the first Sheet that has the Words/Transliteration.
So any time I add a new Arabic title i should see an English Transliteration if I have the word and its Transliteration. If I dont have the word it should stay in Arabic so i know It does not exist in sheet one which should have the WORD and their Transliteration.
Thanks for your help!
I have one problem. Everything it is mentioned in attached excel file, I think this will be an easy one for you.
I have sheet one that shows the word in Arabic in first column and its Transliteration in second column.
Sheet two has The Arabic title in first column and would like column 2 to have a FUNCTION that will generate the English Transliteration by using the first Sheet that has the Words/Transliteration.
So any time I add a new Arabic title i should see an English Transliteration if I have the word and its Transliteration. If I dont have the word it should stay in Arabic so i know It does not exist in sheet one which should have the WORD and their Transliteration.
Thanks for your help!