NukedWhale
01-28-2014, 03:45 PM
Hello and thanks for taking the time to read this. I will try my best to explain what I'm trying to do.
I want to search a user inputted text string for a variety of strings. That user inputted text string will be stored in one cell.
Sometimes users mistype words or use different words that mean the same thing, example: "1st" or "First". I plan to manually build my own library of text variations to check for.
If I want to check the user input string for the word "first", I'll point it to the table/worksheet I've built called "1st", and the formula would check the user inputted text for any variation (based on my table/worksheet supplied definitions) of the word "1st" and return a value of true or 1 if at least on variation is present and 0 or false if none are present.
I'd like to be able to do the same thing for the word 2nd in a different cell.
I've attached an example worksheet to hopefully help. Feel free to fire away with questions. Can it be done with native excel formulas or would I need to write VBA code? I'm pretty sure I can write the VBA code on my own if needed, but native excel functions are preferable.
Thanks!11178
I want to search a user inputted text string for a variety of strings. That user inputted text string will be stored in one cell.
Sometimes users mistype words or use different words that mean the same thing, example: "1st" or "First". I plan to manually build my own library of text variations to check for.
If I want to check the user input string for the word "first", I'll point it to the table/worksheet I've built called "1st", and the formula would check the user inputted text for any variation (based on my table/worksheet supplied definitions) of the word "1st" and return a value of true or 1 if at least on variation is present and 0 or false if none are present.
I'd like to be able to do the same thing for the word 2nd in a different cell.
I've attached an example worksheet to hopefully help. Feel free to fire away with questions. Can it be done with native excel formulas or would I need to write VBA code? I'm pretty sure I can write the VBA code on my own if needed, but native excel functions are preferable.
Thanks!11178