Hi All! I am new to this, so please let me know if I am not following any necessary due process.
My question is as follows...
I have a spreadsheet containing MANY addresses; each row is broken down by ADDRESS, CITY, STATE, and ZIP. I have an additional column (COUNTY) into which I would like to insert a formula that looks at the column containing the CITY for each address and compares it against a list on another sheet in the workbook that lists all of the city's in Delaware County. If the name of the city in the spreadsheet containing addresses is one of the 33 cities contained on the other sheet within the workbook, the formula should return "Delaware", if the city name is not one listed for Delaware county, the formula should return "other".
In the end, I would like to be able to sort my data by the STATE, COUNTY, then CITY.
Can anyone help?
Bookmarks