Need help correcting a possible dual VLOOKUP formula

I am trying to basically combine 2 vlookups to get a value in a cell from the same row. Currently, I am trying to pull data from one worksheet that is generated by our database which includes 3 possible actions for every operator. Every operator does not have all 3 actions, however, when they do have an action, I need to pull all information into my second worksheet and place it in the same row. The data provided by the reoprt only provides positives, meaning that if operator 1 has any action 95, then it will report. But if operator 1 does not have action 96, it will not report. The spreadsheet I am pulling the data into needs to have all 3 actions for every operator.

The looking up a specific cell on worksheet1 from column a and column c and matching them against range A:A and C:C from worksheet 2 has been accomplished with the following:

Formula:

=IF(AND($A$2=Sheet2!$A:$A,Sheet1!$C$2=Sheet2!$C:$C),Sheet2!D2,0)

The issue lies in that if the statement is true, I need to be able to basically perform a Vlookup matching 2 different colums so that I can return the corret data.

Sample attached.

That seems to work for D2, however I don't understand what to change to apply it to D3 and so on.