Android Studio version of an Excel vlookup? -

ok i'm massive noob , apart following lots of tutorials set myself problem , try fix app. therefore i'm trying make little app that'll me when i'm @ work.

basically needs breakdown 4 character string it's individual characters , display them phonetically. if (the user) type in 5f9a it'll display 5 foxtrot 9 alpha. @ work have excel spreadsheet , i'm trying reverse engineer it. spreadsheet has multiple stages, reads characters, converts them ascii , performs vlookup on range of cells each ascii code next it's phonetic pronunciation. looks number 53 (5 in ascii) , looks @ cell next says five.

i've managed translate user input ascii don't know how store , access next set of data. i've been looking sqlite waaaaaay beyond me @ moment , seems far complicated simple?

anyway, know it's cheating asking answer, maybe push in right direction?

the dummy way be:

• get every letter (char) of word

• have switch case gives phonetic equivalent (you have hand)

  string word = yourword; string phonetic; char currentchar;

  for(i=0;i<=word.lenth();i++){     currentchar = word.substring(i, i+1);     phonetic = getphonetic(currentchar) }  string getphonetic(char char){     switch char{          case a:              return alpha;              break;          case b: ....      } }