I have 2 columns on my worksheet, one of names and is supposed to be ranges of numbers like this
enter image description here
I want to search a specific number in the search cell and get the assigned name to that number in the result cell
I tried different formulas, but unable to put all together to get the desired result
New contributor
Alex is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.