Dear Sir
One file attached as example, need help in formula.
I have a data with merge value for example "123 - 124 - 125 - 126 - 127" in one cell
the common thing is " - " space and dash in all cells in between numbers
I need formula where if I wan search record against number 125, it should search in the cell where 125 exist and show me result from record column.
Appreciate someone help here, thanks
One file attached as example, need help in formula.
I have a data with merge value for example "123 - 124 - 125 - 126 - 127" in one cell
the common thing is " - " space and dash in all cells in between numbers
I need formula where if I wan search record against number 125, it should search in the cell where 125 exist and show me result from record column.
Appreciate someone help here, thanks