Searching for a number within a range

I have 1000 line items. Each cell has between 5-50 items formatted as general (EMDL0100015945, EMDL0100015946, EMDL0100015947). How can I search for an item in the range? If using greater then, less than, is this possible if not dealing with numbers? (Example below)

EMDL0100015949, EMDL0100015155, EMDL0100015156, EMDL0100015159, EMDL0100015160, EMDL0100015164, EMDL0100015150, EMDL0100015084, EMDL0100015025, EMDL0100015013, EMDL0100015229, EMDL0100015230, EMDL0100015231, EMDL0100015232, EMDL0100015234, EMDL0100015238, EMDL0100015242, EMDL0100015284

EMDL0100016693, EMDL0100016561, EMDL0100016541, EMDL0100016542, EMDL0100016543, EMDL0100016544, EMDL0100016454, EMDL0100016546, EMDL0100016548, v16549, EMDL0100016550, EMDL0100016551, EMDL0100016552, EMDL0100016536, EMDL0100016511, EMDL0100016512, EMDL0100016477, EMDL0100016481, EMDL0100016483,EMDL0100016484, EMDL0100016403, EMDL0100016103, EMDL0100016039, EMDL0100016040, EMDL0100016026, EMDL0100016027, EMDL0100016028, EMDL0100016029, EMDL0100016030, EMDL0100016031, EMDL0100016032

I have attached a jpg of the worksheet with explanation of desired result

Does this help. So the dilemma is that the number/item I may be looking for may not be in the range in the cell, so I am looking for the closest match, e.g., looking for 1234 but not in the range so 1236 is the closest match. Does this make sense?

The range is all cells in column K. Whan searching for a number/item in the column, the expected result would be a match OR the number/item falls within the range of the cell.
So, if searching for EMDL01000340

it would highlight this cell: K4
EMDl0100000249, EMDl0100000250, EMDl0100000264, EMDl0100000292, EMDl0100000293, EMDl0100000294, EMDl0100000295, EMDl0100000296, EMDl0100000297, EMDl0100000312, EMDl0100000327, EMDl0100000328, EMDl0100000329, EMDl0100000330, EMDl0100000331, EMDl0100000350, EMDl0100000351, EMDl0100000352, EMDl0100000355, EMDl0100000379, EMDl0100000380, EMDl0100000407