Search with multiple criteria/parameters

[Rhodan1970]

Hi everyone,

I could definitely need some help with the following;

Currently I am setting up a workbook which containts a worksheet named dashboard and a worksheet named data1 ( later I expect another sheet data2 to be added)

worksheet data1 contains cummulative performance data of employees roughly in a format with colums that read;

name employee,data1,data2,data3,data4,date

for example

john Doe 22 65 29 71 22-aug-2011
jane doe 61 81 61 99 22-aug-2011
john Doe 34 28 18 53 23-aug-2011
jane doe 77 11 53 72 23-aug-2011


So far so good, now on the worksheet Dashboard I have a list of all the employees in one column ( A5:a10 ) and a row of dates cross (B4:z4), i would like each cell to have extract data from the data1 worksheet based on the date above it on the dashboard sheet .

using an exmaple; cell B5 would have to look at cell A5 containing the name of the employee (John Doe) and look at the date mentioned in cell B4 (23-aug-2011) and use these two criteria to look on data1 worksheet's table and extract the data from they third colum ( 28 in this case)

VLOOKUP seems to go in the direction I want but it seems to miss the ability to add a second parameter/criteria.

If anyone has a solution for this headache I would be most grateful. Can this even be done?

Thanks for any feedback you may provide!