Hi,

I received tremendous help on my first question, but nobody replied to my second question. I'm not sure what made my first post more attractive, but hopefully this one is as well.

I have unique (job) names in Column A and column B has the names of different salespeople (there are 20 salespeople in total). I would like to have a formula that looks at Column A, and based on the salesperson's name (Which I wrote in Cell K1 in this case), returns the Job Name from Column A.

I tried using the following formula which seems to work:

=INDEX($A$1:$A$4,MATCH(K1,$B$1:$B$4,FALSE),1), but this only gives me the First

The only problem with this formula is that only the first Job Name comes up but each SalesPerson has multiple jobs.

Thank you very much in advance for your help.

Regards,

Michael W.