Excel 2007 : Formula to match person using multiple criteria

Hi

In attachment you'll find a workbook. The first sheet shows you the layout of the workbook we use. The second sheet shows you the data we can find in a different workbook.
Can you advise me the formula I should put in column B which will then provide me with the correct Analyst?
If tried this using a normal VLOOKUP function but as soon as he finds the supplier name he takes the Analyst he finds first...

Thanks for all your help.

Kind regards,
Tino XXL

Tino,
Read http://www.beyondtechnology.com/tips015.shtml
and look at the attached with the answer I think you want.