Quickest and Best way to Lookup Clients

[coocoo]

Morning Everyone,

I have 2 tabs, one is a list of clients from database consisting all the chain stores. And one tab is what we have as our clients.

Is there a quickest and best way to lookup from the chain stores tab if they are our clients? I can't really do a vlookup as the name has to match for this to work.

please advise. thanks

 

[Aladin Akyurek]

Try to post tiny samples from both...