Intervals from a Value (Image)

[Ameryjackson]

Hello,

I am struggling with the problem shown in the image below. Any help would be appreciated. Thanks in advance.

https://imgur.com/a/0dcXl

 

[Anthony47]

Next time please don't ask us to recreate your data structure, but publish your file.

Given this structure


Set in H2 the formula

=IF(AND($F2>=INDEX($B$1:$B$10,MATCH(H$1,$D$1:$D$10;0)),$G2<=INDEX($C$1:$C$10,MATCH(H$1,$D$1:$D$10;0))),H$1,"")

Copy down and then copy to the next columns

Bye

 

[Ameryjackson]

Next time please don't ask us to recreate your data structure, but publish your file.

Given this structure


Set in H2 the formula

=IF(AND($F2>=INDEX($B$1:$B$10,MATCH(H$1,$D$1:$D$10;0)),$G2<=INDEX($C$1:$C$10,MATCH(H$1,$D$1:$D$10;0))),H$1,"")

Copy down and then copy to the next columns

Bye

hello Anthony,

Thank you very much for your assistance. At the moment the code is resulting in an error. Did it work for you?

Cheers.

 

[Anthony47]

The formula was correct and tested, BUT when I translated it from my language to English I forgot a couple of "semicolons" that had to be replaced with "comma":
=IF(AND($F2>=INDEX($B$1:$B$10,MATCH(H$1,$D$1:$D$10;0)),$G2<=INDEX($C$1:$C$10,MATCH(H$1,$D$1:$D$10;0))),H$1,"")

So please retry replacing the semicolons ( with commas (,)

Bye