Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to sort through a a few excel columns and can't seem to nail down an easier way besides manually going through line by line. Column A has names where names can repeat, column b has state initials, column c has a number, column d has a start date and column e has an end date. So a name in column a could have say five different states each corresponding to a unique number in column c. I need something that would go through and for each name check if the name had any of the 50 states (plus dc). if they have a state in column b, then I need the values corresponding in column c, d and e. If they don't have that state, return an N/a or blank.

For example, Name1 has AZ and returns number 1234 with start date 01/01/2014 and end date 05/05/2014. Name1 doesn't have CA so returns N/A, N/A, N/A.

Any help is appreciated!

share|improve this question
Version please? (add the relevant tag to the question) –  deleteme Jan 31 '14 at 1:35
It is version 2007 –  Kyle Jan 31 '14 at 1:41
In your example, how do you know "CA" is a member of "States"? Is this perhaps derived from the list of all state values in column B (regardless of association with column A)? If this assumption is correct, a pivot table might work. –  andy holaday Jan 31 '14 at 2:57
Have you tried using a filter? –  Excellll Jan 31 '14 at 14:59

Your Answer


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

Browse other questions tagged or ask your own question.