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
Bookmarks