Finding whether a value is present within multiple ranges

[PSI94]

Good afternoon folks!

I'm incredibly stuck - I've scoured every online resource and keep coming up dry. Hopefully someone may be able to help.

I've attached a pic (I'm using my work PC and it won't allow the add-in). I'm trying to build a formula that will show an X (in column G) if the value in column E is present in the range of numbers - the Start and the End. I'm not bothered outside of these values.

I need the formula to check all ranges in Column A&B and the value in Column E may not necessarily be on the same line as the range to what it may or may not belong.

My heads fried with it! Any help would be much appreciated!

 

[PSI94]

FYI - The current X's are just to show what it will look like with what im trying to build.

 

[Fluff]

How about

=IF(COUNTIFS(A:A,"<="&E3,B:B,">="&E3),"x","")

 

[PSI94]

How about

=IF(COUNTIFS(A:A,"<="&E3,B:B,">="&E3),"x","")

LIFE SAVER!

Thank you so much!!!

 

[Fluff]

You're welcome & thanks for the feedback.