Snasui Excel Forum

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

click on the picture

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,

..

G29

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

Hope this works.

Norkaz

Ty,it works