Index Match inside a text string

[richard1234567891011]

Hi guys,

I need an index match able to read inside a text. This is the issue.

I have these data:

And I have this table:

I need a formula index match in order to read the first table and put the data in the second. In this way:

The data are working in this way: The first number in sub should give back the amount, starting from the second sub, all the other number should give back sold.

Ps: This is a simplified version, in the original one you have also empty subs, so this cannot be solved with a formula index match <>"" so index match or something similar.

Thank you guys,
I hope it is clear.

 

[mehidy1437]

What you want to do with the empty subs?

Try this, formula putted in F:

=IFERROR(IF(INDEX(B:B,MATCH(D2&" Sub "&E2&"*",A:A,0))=0,"Sold",INDEX(B:B,MATCH(D2&" Sub "&E2&"*",A:A,0))),"Sold")

 

[richard1234567891011]

What you want to do with the empty subs?

Try this, formula putted in F:

=IFERROR(IF(INDEX(B:B,MATCH(D2&" Sub "&E2&"*",A:A,0))=0,"Sold",INDEX(B:B,MATCH(D2&" Sub "&E2&"*",A:A,0))),"Sold")
View attachment 1092

Dear Mehidy,
No, it is not working. It is not working because the result is always Sold even if there isn't the sub.
If you have for example Roma Sub 1-2 , so two subs not in the list, the result with the formula is sold sold
You are on the issue. But the solution is not correct.