Quickest and Best way to Lookup Clients

coocoo

New Member
Joined
Aug 14, 2008
Messages
46
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
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,593
Members
409,653
Latest member
rishir

This Week's Hot Topics

Top