So as the title suggests I am looking to make a search/find box (anything else fitting the need actually) that will allow a set of jumbled letters to be placed into a box. Those letters are then run through a certain cell section of user provided information to find the cell using only those letters. The result would then be displayed in the next cell over.
Example:
Typing in "fnseltileakoggsp" in box would find; Platelegs of Kings ind the cell database. Platelegs of Kings would then show up in the cell to the right of the searched letters.
Is this possible? I have looked at many videos and sites on find and search function and comparisons of the two. I have even browsed a few word scramble sites using excel although those are the reverse of what I am looking to do (putting in a word and then mixing the letters around.) I stumbled upon this site and figured to give it a shot. Thank you in advance!
Example:
Typing in "fnseltileakoggsp" in box would find; Platelegs of Kings ind the cell database. Platelegs of Kings would then show up in the cell to the right of the searched letters.
Is this possible? I have looked at many videos and sites on find and search function and comparisons of the two. I have even browsed a few word scramble sites using excel although those are the reverse of what I am looking to do (putting in a word and then mixing the letters around.) I stumbled upon this site and figured to give it a shot. Thank you in advance!