vba - Excel: Insert a range of numbers in one cell -

I am creating an exception template for a customer, and there is one thing I can not understand.

I would like to create a table in Excel that looks like this:

  ABC line 1: 2100-2200 2200-2300 2300-2400  

I am using a VLOOKUP formula, and I want to find numbers in this formula 2152 in the table above the example but Excel can not "see" that number 2152 in my table is actually in cell A1 (Because the cell A1 contains the number from 2100 to 2200).

Can anyone help? Is it possible to do in Excel?

I do not know what you want to return, array array A1: C1:

  = INDEX ($ A $ 1: $ C $ 1; MATCH (1; (E1> = VALUE (left ($ A $ 1: $ C $ 1) Will come; 4)) * (E1 and LT; = VALUE (right ($ A $ 1: $ C $ 1; 4)) 0))  

Do not forget to enter Ctrl Shift to enter the formula E1

in the formula ...