Multiple values in one cell?

[yawriats]

Greetings to the forum!

I have a lookup table that looks something like this:

row 1: "1~5", 2, 4, 5
row 2: "6~10", 2, 3, 6
row 3: "11~20", 3, 3, 5
....

So, person enters a number, clicks on some button, then I use VBA to determine if number is in range "1 to 5" or "6 to 10" (first column) etc. to extract values from that particular row. Is there any way to avoid using VBA? I would also like to avoid this:

row 1: 1, 2, 4, 5
row 2: 2, 2, 4, 5
row 3: 3, 2, 4, 5
...
row 15: 15, 3, 3, 5
...

because I'll have more than 10'000 rows with repeating values (if I'm not repeating values, I have less than 50 rows).

I've considered using drop down list with values "1~5", "6~10"... but I have to enter a number, then determine its range (so, if you enter 15 I have to say: range is "11~20").