Excel is the wrong tool; just use any language that can read and output text.
However you should make sure your approach works first. Afaik you cannot have thousands of else ifs in a row. As for automating, I'd also automate the commands that are run if a match is found.
Scratch that; I'd separate the two things completely.
First, write code that finds which book, chapter and verse was typed. (I'd use a separate text file for each book, btw)
Once you have "Psalms", 1 and 5 stored in three variables, proceed from there. Anything else is madness, especially putting 31,000 else if lines directly in a script. That is the worst possible approach no matter how you slice it.
However you should make sure your approach works first. Afaik you cannot have thousands of else ifs in a row. As for automating, I'd also automate the commands that are run if a match is found.
Scratch that; I'd separate the two things completely.
First, write code that finds which book, chapter and verse was typed. (I'd use a separate text file for each book, btw)
Once you have "Psalms", 1 and 5 stored in three variables, proceed from there. Anything else is madness, especially putting 31,000 else if lines directly in a script. That is the worst possible approach no matter how you slice it.