Multiple Criteria in VLOOKUP?
Posted by JAF on May 16, 2000 7:49 AM
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...