I need help understanding how to screen names
I have tried many other formulas however it was not specific enough.
I am looking for formula that will screen only the first 4 letters of a word and compare to a list of bad first letters (A57 List). When it screens the name it will flag as "FAIL" as it has not passed the screening process.
I have tried IF statements, searching and many different formulas. The all end up screening the whole word and I just need the first 4 letters to not match.
Attached is the file.
Thank you!
*Update*
When comparing to the full A57 List it was flagging words that should not have failed as "FAIL".
This may be issues with case sensitivity. I need it not to be case sensitive because multiple people will be inputting information into the file.
When using MATCH working on desktop excel however did not on Online Excel
Updated Attached File
Bookmarks