I have a table with customers and their addresses (sheet2) and I need to find their GPS locations in sheet1.
I guess the logic would need to be something like this:
find CityName and StreetName in sheet1 where StreetNo is between minStreetNo and maxStreetNo
return GPS X and GPS Y
Can someone please help me with the formula or VBA code?
Thank you very much!
Example.xlsx
Bookmarks