Page 1 of 1

wildcard issue

Posted: Wed Sep 15, 2021 3:24 pm
by sna
Hi Dear,

I need your help how to solve this problem ,I use index with match wrap with * but The problem is that I cant distinguish between SR22 and R22 when search for R22 :X

I also attached a template

Re: wildcard issue

Posted: Wed Sep 15, 2021 3:59 pm
by puriwutpokin
click on the picture

Re: wildcard issue

Posted: Wed Sep 15, 2021 5:28 pm
by sna
I mean this output in column G(G29) is not correct .
OUTPUT
Cirrus SR22
4
1
5
0
SR22
It should be
Robinson R22
1
1
2

Best Wishes,

Re: wildcard issue

Posted: Wed Sep 15, 2021 5:49 pm
by norkaz
..

G29

=INDEX(A:E,IFERROR(MATCH($H$12,F:F,0),MATCH("*"&$H$12&"*",F:F,0)),ROW(A1))

Hope this works.

Norkaz

Re: wildcard issue

Posted: Fri Dec 24, 2021 6:55 pm
by sna
Ty,it works