|I must be missing something here.|
Are those the only three strings you are searching for?
I assumed you had many different entries in Column A with many different strings to extract.
If all you have are those 3 strings to search for and extract, then this will work also:
"Handicap","Maiden Stakes"),"Selling Stakes")
A formula tip:
When you are using an IF function to check X number of criteria, and you know that at least one of the criteria will always be TRUE, you only need X-1 IF's.
For example, in your situation, you have 3 criteria: the 3 strings. If you know that at least one of them will always be found, then you only need to check for 2. If those 2 don't exist, then the 3rd one must.
You'll note that I don't search for Handicap since if Selling and Maiden don't exist, the answer must be Handicap.
In addition, I don't bother searching for Stakes since it's common to both the Selling and Maiden strings.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.