Complicated Excel formula question involving text-search and Japanese characters. Can you help?
I have two spreadsheets.
contains a list of Japanese vocabulary words I need to learn for the JLPT this year. Spreadsheet B
contains a list of Japanese characters in one column along with the characters "Heisig number" (an ordinal number indicating where that character appears in the book "Remembering The Kanji" by James Heisig).
I want to add a column to Spreadsheet A that will contain the highest Heisig number among the characters that make up the vocabulary word. The purpose of this is to sort the words in Spreadsheet A so that I can memorize only the words that can be written using the Kanji I've learned so far.
Confused? Here's an example: Spreadsheet A, cell 57A contains the word "朝寝坊". Using Spreadsheet B to looking up the 3 characters in that word, I find the Heisig number for 朝 is 52, 寝 is 1150, and 坊 is 492. 1150 is the highest of those 3 numbers, so I'd like Spreadsheet A, cell 57B to read "1150". Is there a way to set up a formula to do this? I've never pushed Excel this far before.
Thank you in advance, Hive Mind!