I have a table with about a 1,000 client name and client numbers. When working in Excel I periodically need to lookup a client number. (See Sample Table Below).
I am using =VLOOKUP(C2, A2..B11,1,TRUE) to get the actual Client Name and
=VLOOKUP(C2, A2..B11,2,TRUE) to get the Client Number
I have two problems.
1. Unless you enter the query the exact client name, you get the client name and client number of the previous client. I understand this is the way VLookup works. Can that aspect be modified in some way to multiple answers?
2. There are several incidents of business or individuals with similar names. Same question as above?
3. We could expand this into looking up TaxID numbers, phone numbers etc. if we could solve this problem. And please do not tell me that we could do this much easier with a database. I understand but we are always working in Excel and it would be very convenient.
The entire office in running Excel 2003
Client Name Client Number Query Client Answer Client # Answer
Big City Bakery 1200 Valley The Donut Shoppe 7250
Big City Tires 1430
Carefree Chiropractic 2010
Mountainview Lodge 5460
Realty Associates 6980
The Donut Shoppe 7250
Valley Electrical Supply 8810
Valley Feed Store 8820
Valley Plumbing Co. 8830
Valley Supply Company 8840