Multiple Criteria in VLOOKUP?

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...