Vowel hook search

[makinmomb]

In scrabble a hook is termed to add a word at the end of a word or front

CAM aeiops
MAC ehks
CAN egnsty
OCA s
CAP aehios
PAC aekosty
ARC hos

I have this on A1 and B1

I need a formula to search for all words that can take aeio
if the formula does the work correctly then expected results are as follows

CAM aeiops yes
MAC ehks
CAN egnsty
OCA s
CAP aehios yes
PAC aekosty
ARC hos

[kasan]

In case I got it right you need to find all matches that contains letters.
Try this one.

Please Login or Register  to view this content.

[makinmomb]

Very correct , but on result i need you to plug CAM and PAC
those words being able to take AEIO

[JohnTopley]

Try

=IF(SUM(--(ISNUMBER(SEARCH({"a","e","i","o"},A1))))=4,"yes","")

[makinmomb]

John almost correct
It does plug YES where applicable maybe you are missing cell reference of search ?

[kasan]

Small corrections in prev file.

[JohnTopley]

What is wrong?

[makinmomb]

Thank you Kasan for editting the macro

[JohnTopley]

See attached ..

[makinmomb]

Thank you John again . I need a non macro version for my collection .