I want to return information based on a name I select from a drop down list
of salespeople. Setting up the basic equation was simple enough.

In a sheet (call it JOSH), I set up for an indivudual salesperson's account,
I entered this formula.

=if('techdata'C9="josh",A9,"") where A9 was a PO # i wanted to return.

This works fine on an individual row basis, however I would like to set up
an equation that would search a whole column (C:C) for any cell that "josh"
is selected from a drop down list and return cell A from that cell's row.

I have a general idea, but I wonder if duplicates would be an issue.

=if('techdata'C:C="josh",A:A,"")
i doubt this would work, is there a way that i could search and only return
the same PO # once?

Maybe i am just a wishful thinker. Hope I was clear enough.

Cheers