Google Translate Function - quick question on syntax

Hi team,

So I found this super great function to translate copy in Excel using

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I found all "source" and "target" languages on a google translate page. If I want to translate from, let's say, English to German, the formula would look like:

Please Login or Register  to view this content.

This works well, however, it only works if "en" and "de" are "hardcoded" in the formula. If I use a variable here it doesn't work, even if those cells contain "en" including the quotation marks. I've also tried to use & to append the quotation marks before and after the referenced cell, but that doesn't seem to work either.
Is there anyone who knows how to tweak this code so I can reference a cell for the "en" and "de" values?

Thanks so much!

False alarm! I got it to work. YAAY.

Please Login or Register  to view this content.