First Letter Equal to Fifth and

[makinmomb]

KATAKANA
AGACANTE
ACANTHAE
ANALECTA
VANADATE
ANATHEMA

I want formula on b1 to plug y on KATAKANA

Logic
If 1st letter is equal 5th
and
If 2nd letter is equal 6th
and
If 4th letter is equal 8th

[JohnTopley]

Please Login or Register  to view this content.

[Glenn Kennedy]

or:

=IF(A1="","",IF(AND(MID(A1,1,1)=MID(A1,5,1),MID(A1,2,1)=MID(A1,6,1),MID(A1,4,1)=MID(A1,8,1)),"Y",""))

[thenewkidd]

My solution is attached.

A2 and down is the list you provided above.

I created a number logic in row 1 (B1, C1, D1, E1)
B1 you can match numbers base on 15 (1 and 5)
C1 match numbers on 26 (2 and 6)
etc.
then in Cell B2 put =MID($A2,VALUE(LEFT(B$1,1)),1)=MID($A2,VALUE(RIGHT(B$1,1)),1)
You can copy this down and across and it will reference the numbers in row 1 to know what letters have to match in what position.

If I missed the mark, upload an example sheet of what you want as an outcome and we can work with that.

Regards.

[makinmomb]

Thank you all , working

[Glenn Kennedy]

You're welcome & thanks for the feedback!