its kinda hard to explain but ive writen about what Im trying to find along side the data in the excel document which makes it alot easier to understand. Basically which im trying to do is:

A formula that can find the same value between an x value and randomized x value ( in two different tables) , then calculate weather the randomized x values y value (( x,y)) is equal to or less than the other x values y value and state weather it is true or falue.

eg. In two different tables :
(1, 3.2) (1 point for a line) & ( 1, 18.1) (randomized x and y)
the formula needs to make a search for the same x values ( in this case finding the two 1 values) ... and identifying the randomized y value is larger than the y value as:
3.2 < 18.1
therefore stating it is false for not being larger than the randomized number

Kindregards and thanks guys

finding points within a region.xlsx