I have 2 tables like the ones shown and I need help to get a string that can help me to update the "Address" column in the left table based on the criteria in the right table: If X > MinX and X < MaxX and Y > MinY and Y < MaxY then return Address for each Location. There must be some way to do this, right??
ExcelHelp.PNG
Bookmarks