Spreadsheet: 857366d1706385648-display-multiple-values-in-different-cells-if-values-between-two-numbers-display-multiple-values-in-diferent-cells-dj
Sheet: Sheet1

Values I will choose | result expected if I chose 1 - 1,5 I need excel to find all the values in colum D which are next to a value betwen 1 - 1,5 same If I chose 3,5 - 4 or any other interval from  he column H |  |  |  |  |  | IF(A1<>"";OFFSET(Trss;MATCH(A1&"*";Trss;0)-1;;COUNTIF(Trss;A1&"*");1);Trss)
1 - 1,5 | ACETIC ACID |  | ISOPENTANAL | 1.201 |  |  | OFFSET(Tr;0;0;COUNTA(TrS);1) |  |  |  | 1 - 1,5
 | ACETONE |  | FURFURAL | 3.79 |  |  | Tr ; [NAME] ; [NAME] |  |  |  |  | ACETIC ACID
 | ACETATE ETHYL |  | ACETIC ACID | 1.45 |  |  |  |  |  |  |  | ACETONE
 | ISOPENTANAL |  | [NAME] 36 | 2.15 |  |  | Column1 | Column2 |  |  |  | ISOPENTANAL
1,5 - 2 | ETHYL ACETATE |  | ACETATE ETHYL | 1.49 |  |  | 1 - 1,5 | 1 |  |  | 1,5 - 2
 | ETHYL PROPIONATE |  | ETHYL ACETATE | 1.6 |  |  | 1,5 - 2 | 2 |  |  |  | ACETALDEHYDE DIETHYL ACETAL
 | ACETALDEHYDE DIETHYL ACETAL |  | RHO VALERIQUE | 1.68 |  |  | 2 - 2,5 | 3 |  |  |  | ACETOINE
 | ETHYL BUTYRATE ISO |  | ACETATE BUTYLE | 3.8 |  |  | 2,5 - 3 | 4 |  |  |  | ETHYL ACETATE
 | ACETALDEHYDE DIETHYL ACETAL |  | ACETOINE | 1.58 |  |  | 3 - 3,5 | 5 |  |  |  | ETHYL BUTYRATE ISO
 | HEPTANE n |  | ETHYL PROPIONATE | 1.9 |  |  | 3,5 - 4 | 6 |  |  |  | ETHYL PROPIONATE
 | ETHYL PROPIONATE |  | RHO C6 (HEXANAL) | 2.49 |  |  | 4 - 4,5 | 7 |  |  |  | ETHYL PROPIONATE
 | ACETOINE |  | HEPTANE n | 1.8 |  |  | 4,5 - 5 | 8 |  |  |  | HEPTANE n
 | RHO VALERIQUE |  | PRENOL | 2 |  |  | 5 - 5,5 | 9 |  |  |  | RHO VALERIQUE
3,5 - 4 | FURFURAL |  | ACETALDEHYDE DIETHYL ACETAL | 1.64 |  |  | 5,5 - 6 | 10 |  |  | 3,5 - 4
 | [NAME] 14 |  | ETHYL BUTYRATE ISO | 1.86 |  |  | 6 - 6,5 | 11 |  |  |  | ETHYL LACTATE
 | ETHYL LACTATE |  | PRENOL | 2 |  |  | 6,5 - 7 | 12 |  |  |  | FURFURAL
 | [NAME] 13 |  | TOLUENE | 2.3 |  |  | 7 - 7,5 | 13 |  |  |  | [NAME] 13
 | [NAME] 43 |  | ACETALDEHYDE DIETHYL ACETAL | 1.64 |  |  | 7,5 - 8 | 14 |  |  |  | [NAME] 14
 | ACETATE BUTYLE |  | LIMEDIENE | 2.45 |  |  | 8 - 8,5 | 15 |  |  |  | [NAME] 43
2 - 2,5 | [NAME] 36 |  | ETHYL BUTYRATE | 2.23 |  |  | 8,5 - 9 | 16 |  |  | 2 - 2,5
 | LIMEDIENE |  | [NAME] 43 | 3.6 |  |  | 9 - 9,5 | 17 |  |  |  | [NAME] 36
 | ETHYL BUTYRATE |  | [NAME] 13 | 3.9 |  |  | 9,5 - 10 | 18 |  |  |  | LIMEDIENE
 | TOLUENE |  | ACETONE | 1.379 |  |  | 10 - 10,5 | 19 |  |  |  | PRENOL
 | RHO C6 (HEXANAL) |  | ETHYL LACTATE | 3.68 |  |  | 10,5 - 11 | 20 |  |  |  | PRENOL
 | PRENOL |  | ETHYL PROPIONATE | 1.9 |  |  | 11 - 11,5 | 21 |  |  |  | RHO C6 (HEXANAL)
 | RHO C6 (HEXANAL) |  | [NAME] 14 | 3.99 |  |  | 11,5 - 12 | 22 |  |  |  | TOLUENE
 |  |  |  |  |  |  | 12 - 12,5 | 23
 |  |  |  |  |  |  | 12,5 - 13 | 24
 |  |  |  |  |  |  | 13 - 13,5 | 25
 |  |  |  |  |  |  | 13,5 - 14 | 26
 |  |  |  |  |  |  | 14 - 14,5 | 27
 |  |  |  |  |  |  | 14,5 - 15 | 28
 |  |  |  |  |  |  | 15 - 15,5 | 29
 |  |  |  |  |  |  | 15,5 - 16 | 30
 |  |  |  |  |  |  | 16 - 16,5 | 31
 |  |  |  |  |  |  | 16,5 - 17 | 32
 |  |  |  |  |  |  | 17 - 17,5 | 33
 |  |  |  |  |  |  | 17,5 - 18 | 34
 |  |  |  |  |  |  | 18 - 18,5 | 35
 |  |  |  |  |  |  | 18,5 - 19 | 36
 |  |  |  |  |  |  | 19 - 19,5 | 37
 |  |  |  |  |  |  | 19,5 - 20 | 38
 |  |  |  |  |  |  | 20 - 20,5 | 39
 |  |  |  |  |  |  | 20,5 - 21 | 40
 |  |  |  |  |  |  | 21 - 21,5 | 41
 |  |  |  |  |  |  | 21,5 - 22 | 42
 |  |  |  |  |  |  | 22 - 22,5 | 43
 |  |  |  |  |  |  | 22,5 - 23 | 44
 |  |  |  |  |  |  | 23,5 - 24 | 45
 |  |  |  |  |  |  | 24,5 - 25 | 46