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!