MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Multiple Criteria in VLOOKUP?


Posted by JAF on May 16, 2000 7:49 AM

Hiya folks

Yet another taxing little problem to exercise your brain cells.

I have a list of accounts complete with client code and product code, and a seperate list of product code and product description.

What I would like to do is use a VLOOKUP to get the descriptions onto the main list - but there's a problem. Each product can have a different description depending on which client code it comes under (as follows)
Client1, Product Code: ABC1, Description: 5 Year Fixed Term
Client2, Product Code: ABC1, Description: 3 Year Variable Term.

I suppose I could sort and filter the lists and do seperate lookups for each, but there has to be a more elegant solution.

Over to you...


Posted by Keith Hoar on May 17, 2000 11:21 AM

Posted by Keith Hoar on May 17, 2000 11:28 AM

Sorry, the first message disappeared.

First, insert a new column between "Product Code and "Description" on your data tab. Load the new column with "Client Code & Product Code" (concantenation). make the new column the leftmost column in the named lookup range.

Then: VLOOKUP(Client Code & Product Code, LkUpRange, ColumnNo, FALSE).

HTH
Keith Hoar