VLookup - retrieve number of bracket

[sh1ne]

Hello,

How should I act when I want to retrieve number of bracket where value I'm looking for is?


Let me visualize my problem:

Bracket ID	Value I'm looking for	Bracket Number	Bracket Content
<formula>	101	A	99 88 100 98 103
<formula>	102	B	87 55 33 58 101
<formula>	103	C	102 108 109 112
<formula>	104	D	111 104 198 175

<tbody>
</tbody>

So basicaly formula should give me number of bracket where value(which I'm looking for) is. Value from row 2 can be in bracket located in row 20. Let's imagine that count of brackets it's 1/4 of total values. How can I deal with it?
I'm struggling with this probably due to that multiple values are located in one cell and all is splitted by space.

Any tips? Thanks

 

[Fluff]

How about

Book1
	A	B	C	D
1	Bracket ID	Value I'm looking for	Bracket Number	Bracket Content
2	B	101	A	99 88 100 98 103
3	C	102	B	87 55 33 58 101
4	A	103	C	102 108 109 112
5	D	104	D	111 104 198 175
Log

Cell Formulas
Range	Formula
A2	=INDEX($C$2:$C$5,MATCH("*"&B2&"*",$D$2:$D$5,0))

 

[sh1ne]

How about

Thanks a lot! It looks that I tried with wrong formula.

Have a nice day mate.

 

[Fluff]

You're welcome & thanks for the feedback