I maintain a Travel Spreadsheet and want to incorporate searchability.
I have it started, based on another sheets search ability on the "Search, Beta" sheet.
With the formulas, I have, I cannot get only United States cities to list in "Possible Cities" or only Europe cities. Currently when I copy down the formula I also get duplicates but not sure where to put in the formula to not list duplicates.
Eventually, I'd like "Possible Cities," "Possible Hotels," "Possible Food," etc to list what everything when EITHER State or City is typed in by the user.
Hopefully I can get some help. Most of the formulas I found online and know somewhat how they work but am clueless when having to nest more parts to the formula.
Michael
Bookmarks