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!
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!