I'm making a sheet that functions like a translator.
English words are in Column Q
Foreign words are in Column R

what i want to be able to do is type the english word in A1, and have the foreign word appear in A2

Any suggestion?