Hello
In my "data" page I have an A column with text strings consisting of 2 letters

I have a page called "translation models" where the 2 letters can be find in the A column and a translation to the code in the B column.

Page Data
column A /column B
CT / ?
DB / ?
CB / ?

Page Translation models
columnA / column B
CT / 12345
CB / 78910
DB / 54321
This list consist of more than 20 codes so far.
I want to find a code for my B column ("data") that check the entire A column ("translation models) and returns the B value (translation models) to the B column (Data)

I have tried this:

=IF($A2='Translation Models'!$A$13;'Translation Models'!$B$13;IF($A2='Translation Models'!$A$14;'Translation Models'!$B$14;IF($A2='Translation Models'!$A$15;'Translation Models'!$B$15;IF($A2='Translation Models'!$A$16;'Translation Models'!$B$16;.....etc

But it doesn't work when the list gets to long

Any help would be appreciated