Search within a Multiple Range of numbers in a cell in Excel?

I have 2 columns on my worksheet, one of names and other is supposed to be ranges of numbers like this

enter image description here

Formula will go in the result cell and it will take input form the Search Cell.
I want to search a specific number in the search cell and get the assigned name to that number in the result cell basically

I tried different formulas, but unable to put all together to get the desired result

>Solution :

Formula in G2:

=FILTER(B1:B3,MAP(C1:C3,LAMBDA(x,LET(y,TEXTSPLIT(x,", "),OR((--TEXTBEFORE(y,"-",,,,y)<=F2)*(--TEXTAFTER(y,"-",,,,y)>=F2))))))