Help with Lookups

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I am not sure how to program this, I assume some combo of match and
vlookup as I have googled around....

My goal is to return a list of people within a certain state, other
than the person whose record I am referencing. This would be returned
in my COLUMNC-GOAL as below. Any ideas how to set this up?

Let's assume the data like this:
COLUMNA-STATES COLUMNB-NAMES COLUMNC-GOAL
Ohio Greg Piller Dan Frumm
Ohio Dan Frumm Greg Piller
California Jim Smith Tom Wilson and
Greg Miller
California Tom Wilson Jim Smith and
Greg Miller
California Greg Miller Jim Smith
and Tom Wilson
 
a lookup probably isn't what you need. Have you tried the autofilter?
if you filtered for OHIO, you'd see two rows
 
Back
Top