I would like to provide City suggestion to the spreadsheet user.
This suggestion is based on two criteria (on a same row) :
- the country (via the Country iso code)
- the zipcode
Since the user provides those two information, I want, in a third cell to give him or her suggestions for a City (It is possible to have many City for a same Zip code).
Bonus: if user edits country / zip code I want to empty or invalidate the city if there is no known match.
In another sheet (in the same file), I have a table witch acts as a reference with all country iso, zip code and cities.
Any idea how to do this ?
Thanks by advance