unfortunately the client list is about 1500 entries, and we have clients like
Washington Mutual and Wells Fargo, and they have so many branches and agents
that looking for the exact client is still tedious, just trying to find an
easy way out. I wasn't sure if it was even possible to run some kind of
lookup that can display multiple results.

"JE McGimpsey" wrote:

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.