Searching through the values with condition

Hello,
I have a list of points. Each point has x and y coordinates. I also have cells. Each cell has 4 boundaries - left, right, top and bottom. I need to create a function for each cell that will run through the list of points and if it finds a point that it's x coordinate is bigger than left boundary and smaller than right boundary and y coordinate is bigger than bottom boundary and smaller than top boundary, function will put a "1" in a cell. If it runs through all the points and doesn't find such a point - function will put a "0" in a cell.

I will give an example:
func.GIF

I need to enter a function to cells G5 and G6. Function in cell G5 will run through x and y coordinates of point and will find a point #1 which x coordinate is indeed left<x<right and bottom<y<top, so G5 cell will receive a "1" value. On the other hand, function in cell G6 will run through the points' x and y coordinates and will not find any point that fits the requirements and G6 will receive a "0" value.

Can somebody help me with writing such a function?
Many thanks!

Georgiy.

Searching through the values with condition.xlsx
This is what i understand your question. Hope it help

Thank you, wenqq3!
But in your example, cell 2 received "1", but there is no point that it's x is between 2<x<3 and y such 5<y<6, so it was supposed to receive a "0".


I mean, function in each cell should contain constraints on both X and Y - so cell should receive "1" only if X and Y coordinates of some point fit the cell's boundaries.

Hello,

Please check if the attached file is what you are looking for.

An alternative is to use the following formula

Please Login or Register  to view this content.

This one is not an array formula. You can paste it on B10 on the sample file and drag it down.

Lemice 's answer should be the one you want