INDEX, MATCH and OR ISSUE

Hello,

I am trying to use a formula that reports a "YES" or "NO" based on certain text criteria found in specific cells when referenced by index/match to a specific name and date. In the past I feel like I have used the Asterisk to allow for text found in the cells such as DPY, TDY, LVE, etc to allot for the texts to also contain numerics such as DPY1 DPY2, TDY4, LVE2, LVE4, etc. I created the formula to use "DPY*" to try and capture all versions of DPY with numbers contained afterwards, but When the formula works through itself, it registers false for finding these texts in the cells when the asterisk is used. When it isn't used, it finds the specific versions of the text only criteria. Is there anyway I can use my formula to find the criteria I'm looking for to allow for numbers after the character texts? A sample of the formula is here without the asterisks contained:

=IF(INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH("NOTES",$1:$1,0)))="DNA","NO",IF(INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH("NOTES",$1:$1,0)))="BLANK","NO",IF(OR(INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="DPY",INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="ROD",INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="LVE",INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="TLV",INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="CLV",INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="QTRS",INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="APPT",INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="TDY",INDEX($A$1:$IU$32,MATCH($B71,EchoFlightPersonnel,0),(MATCH(C$69,$1:$1,0)))="TDA"),"NO","YES")))

I can upload the workbook if needed later...

Thank you for your help.

I think uploading a file would be helpful, but maybe you could use the LEFT formula to help (i.e., LEFT(A1,4)="TEST" (A1 could be TESTING and it would match).

I have deleted the real names of individuals that would?ve been identified?those last names are One or two character identifiers?no one could be identified by that ?but I guess thanks for worry?.

I will seek help elsewhere if it?s an issue

Add the LEFT formula to all your index/matches, like so:

LEFT(INDEX($A$1:$IU$32,MATCH($B79,EchoFlightPersonnel,0),(MATCH(D$69,$1:$1,0))),3)="TDY",

(The "3" near the end of the statement should match the number of letters you are matching to.)