Vlookup or Match with Two Conditions in Excel Help

Hello all,
I would like to pull MKT info from table 2 into table 1 if both conditions (Account and Date in Table 1 Matched Table 2). I believe Vlookup can only do 1 condition. Any help would be greatly appreciated as this is a sample of 10,000 rows.

So this example, I would like to pull in the MRK value of 858023.05 to Table 1 because Account (20600025522087) and Date (1/1/2012) matched in both table.

TABLE 1
ACCT DATE
20600025522087 1/1/2012
20600025522087 2/1/2012
20600025522087 3/1/2012
20600025522087 4/1/2012
20750733737854 6/1/2015
20750733737854 7/1/2015

TABLE 2
ACCT DATE PMKT MKT
20600025522087 1/1/2012 840553.94 858023.05
20600025522087 2/1/2012 858023.05 887728.18
20600025522087 3/1/2012 887728.18 893642.31
20600025522087 4/1/2012 893642.31 890349.76
20600025522087 5/1/2012 890349.76 836927.99
20600025522087 6/1/2012 836927.99 870952.61
20600025522087 7/1/2012 870952.61 883830.70
20600025522087 8/1/2012 883830.70 890491.72
20750733737854 6/1/2015 .00 1386139.66
20750733737854 7/1/2015 1386139.66 1430645.93
20750733737854 8/1/2015 1430645.93 1333955.21
20750733737854 9/1/2015 1333955.21 1259204.67
20750733737854 10/1/2015 1259204.67 1326448.00
20750733737854 11/1/2015 1326448.37 1319517.74Capture.PNG

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

You need one formula if the order is PMKT and MKT

For PMKT and MKT down and forward range C3:D8

=INDEX(G$3:G$15,MATCH($A3&$B3,INDEX($E$3:$E$15&$F$3:$F$15,,),0))