Help with Lookups

[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

 

[Patrick Molloy]

a lookup probably isn't what you need. Have you tried the autofilter?
if you filtered for OHIO, you'd see two rows

 

[Eduardo]

Hi,
what you need is data validation dependent list see Debra web, it explains
step by step how to do it

http://www.contextures.com/xlDataVal02.html

if this helps please click yes, thanks