How to use VLOOKUP for multiple criteria

[vademo0o]

Hi everyone-

I am trying to create a VLOOKUP formulation for the table shown as below

Project Help.JPG

I have 2 worksheets. The first sheet is a report I receive everyone month and the second worksheet is organized report. 2 worksheets have the same date format therefore the data is not an issue. What I am trying to if Project ID=1 and and Resource=A, I would like to copy this data to other worksheet. I can use array's but I do not want prefer it. So the data for 1/1/2013 on worksheet 1 data will be the data for 1/1/2013 on worksheet 2

What I thought was "=VLOOKUP(IF(AND(A2='Plain Data'!A2,ASAP!B2='Plain Data'!B2), $A$1:$AA$99, 3, 0)

[FDibbins]

Please dont post a picture of your sample worrkbook -post the sample workbook. No-one wants to retype our data

[vademo0o]

I have attached the document. I also want to tell everyone project has only 1 time entry for one resource so I do not need to worry about sum.