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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Bracket ID[/TD]
[TD]Value I'm looking for[/TD]
[TD]Bracket Number[/TD]
[TD]Bracket Content[/TD]
[/TR]
[TR]
[TD]<formula>[/TD]
[TD]101[/TD]
[TD]A[/TD]
[TD]99 88 100 98 103[/TD]
[/TR]
[TR]
[TD]<formula>[/TD]
[TD]102[/TD]
[TD]B[/TD]
[TD]87 55 33 58 101[/TD]
[/TR]
[TR]
[TD]<formula>[/TD]
[TD]103[/TD]
[TD]C[/TD]
[TD]102 108 109 112[/TD]
[/TR]
[TR]
[TD]<formula>[/TD]
[TD]104[/TD]
[TD]D[/TD]
[TD]111 104 198 175[/TD]
[/TR]
</tbody>[/TABLE]


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