Find the first vowel sound from a name

[khanaran]

Hi

I have a first name that from here I need a formula help in order to

1. find the first letter and paste into T10

2. Find the first vowel sound from the name and past into T12


Thank you in anticipation for all your help

rajan

[6StringJazzer]

Finding the first letter for a name that always begins in E8 is trivial and I'm surprised to see the question

=E8

Be careful to distinguish a vowel from a vowel sound. Finding the first vowel sound is a linguistics exercise that cannot be reasonably done in Excel. You can easily find the first letter that is a vowel:

=INDEX(E8:Z8,MIN(IFERROR(MATCH({"a","e","i","o","u","y"},E8:Z8,0),99)))

Enter this as an array formula. After typing in the formula, do not hit ENTER--hit CTRL+SHIFT+ENTER. You have done it correctly if the formula in the formula box has {braces} around it. You cannot type in the braces; they are just an indicator that it is an array formula.

The first vowel sound in Yvonne is the Y. However, the first vowel sound in Yasmine or Yasser is the A.

[kvsrinivasamurthy]

In T10

=E8

In T12

=IFERROR(INDEX($E$8:$L$8,AGGREGATE(15,6,COLUMN($E$8:$L$8)/(ISNUMBER(SEARCH($E$8:$L$8,"aeiou"))),1)-COLUMN($D8)),"")

[Bo_Ry]

Please try at
T10
=INDEX(E8:L8,MATCH(0,INDEX(-ISNUMBER(SEARCH(E8:L8,"aeiou")),),))
or
=INDEX(E8:L8,MATCH(0,INDEX(-(E8:L8=T12),),))

T12
=INDEX(E8:L8,MATCH(0,INDEX(-ISERR(SEARCH(E8:L8,"aeiou")),),))