I don't fully understand your requirement, would you please elaborate and post how should be applied the criteria on 2nd worksheet? Please post manually the output data wanted and how have you reached it.
Sorry for late reply, you have a very goood point there its the distance from main store, which is located in EAST. which matters.
& for how will you distinguis A1 = North or East.. be i was referring to google map but just for now u think its just east/west/north/south later on i will dig the old files to use the old as reference