If you just want to see which sales reps have claimed a client, do an
autofilter on the client column.

In article ,
bclancy12 wrote:

Does anyone know how to use a vlookup, or any kind of lookup formula when
there are more than one result?? ie if I am searching the name of a client,
and want to know who the sales rep is, but more than one sales rep has
labeled the client as "their client", is there a way to see all of the names
of the sales rep that have that client on their client list.