Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Okay, so we have an email database with the home address for each person in it and we need to know if we can enter a formula to search the database to find the specific cities. The column for cities is in the "G" column.

share|improve this question
I think you're looking for the vlookup command. – Spütnik May 22 '12 at 21:04
Please don't call a table or spreadsheet a database. The day our functional lead starts calling herself a DBA, I quit! – krowe Nov 8 '14 at 19:44

2 Answers 2

Welcome to Superuser. Knowing what version you are using helps you get a more specific answer.

The easiest solution would be to just filter your data by city. In earlier versions this is done by making a list and sorting by the column you want. In newer versions you can make a table with the data and sort it using the filter buttons in the column headings.

Here are detailed instructions how to make a list in Excel 2003.

Here are instructions how to make a table in Excel 2010.

share|improve this answer

Just highlight that column (by clicking at the top) or select the data cells you want and hit Ctrl-F. Then your search is limited to just the selected data.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.