Move/match Stock Ticker data from one Excel file to another

Good day,

I am looking to copy data from one file (Titled - "Max IS formated") to another (Titled - "Max multi quote"). The macro or vlookup has to match both a letter and a date in order to copy to the correct cell.

for example, copy Aux1 and Aux2 from file "Max IS formated":

Ticker Trans Date Aux1 Aux2
A 11/26/2012 10
A 11/29/2012 7
A 12/18/2012 3
A 5/17/2013 3
AAN 9/10/2012 127
AAN 11/1/2012 9
AAN 7/26/2012 7
AAN 9/7/2012 5
AAON 12/6/2012 9


to file "Max multi quote" into the proper cell using ticker and date:

Date Open High Low Close Volume Adj Close Ticker Aux1 Aux2
6/27/2012 38.44 38.68 38.15 38.35 1541800 37.95 A
6/28/2012 38.05 38.14 37.18 37.72 2001500 37.32 A
6/29/2012 38.35 39.3 38.35 39.24 2645800 38.93 A
7/2/2012 39.53 39.61 38.5 38.91 1737500 38.6 A
7/3/2012 38.82 39.73 38.82 39.54 970700 39.23 A
7/5/2012 39.26 39.84 39 39.37 1605500 39.06 A
7/6/2012 38.8 38.83 37.58 37.97 3336400 37.67 A
7/9/2012 37.95 38.26 37.4 37.62 2270000 37.32 A
7/10/2012 38.17 38.59 37.11 37.49 2201600 37.2 A
7/11/2012 37.45 37.62 36.82 37.19 1930800 36.9 A
7/12/2012 36.89 36.91 36.25 36.52 2897100 36.23 A
7/13/2012 36.55 37.44 36.36 37.04 3381600 36.75 A
7/16/2012 36.82 37.09 36.58 36.83 1751400 36.54 A
7/17/2012 36.88 37.41 36.5 37.34 2065500 37.05 A
7/18/2012 37.13 38.79 37.13 38.36 2804900 38.06 A
7/19/2012 38.16 38.6 37.96 38.46 2123400 38.16 A
7/20/2012 38.21 38.21 37.44 37.56 1839600 37.26 A
7/23/2012 36.82 36.86 36.27 36.69 2199000 36.4 A
7/24/2012 36.6 36.67 35.32 35.61 3858500 35.33 A
7/25/2012 35.92 36.54 35.76 36.14 1778200 35.86 A
7/26/2012 36.94 37.5 36.4 36.61 3053800 36.32 A
7/27/2012 36.85 38.14 36.69 37.94 2885400 37.64 A
7/30/2012 37.92 38.3 37.69 38.18 3281300 37.88 A
7/31/2012 38.03 38.71 38.02 38.29 2184800 37.99 A
8/1/2012 38.73 38.73 37.92 38.18 1898400 37.88 A
8/2/2012 37.9 38.23 37.05 37.75 2224200 37.45 A
8/3/2012 38.54 39.48 38.51 39.11 1824900 38.8 A
8/6/2012 39.73 39.9 39.2 39.23 2007900 38.92 A
8/7/2012 39.35 40.57 39.25 40.25 2201300 39.93 A
8/8/2012 40.29 40.74 40.11 40.66 1934600 40.34 A
8/9/2012 40.56 40.97 40.44 40.8 2191200 40.48 A
8/10/2012 40.43 40.55 39.83 40.53 1959600 40.21 A
8/13/2012 40.27 40.7 40.15 40.38 1860800 40.06 A
8/14/2012 40.62 40.95 40.25 40.49 1994400 40.17 A
8/15/2012 40.33 40.85 39.8 40.48 2838300 40.16 A
8/16/2012 37.5 38.17 36.76 37.15 12796100 36.86 A
8/17/2012 37.23 37.29 36.81 37.22 5377700 36.93 A
8/20/2012 37.02 37.18 36.55 36.68 3973000 36.39 A
8/21/2012 36.9 37.21 36.66 37.13 5375900 36.84 A
8/22/2012 37.05 37.48 36.79 37.46 4383600 37.17 A
8/23/2012 37.23 37.56 37.07 37.47 4492200 37.18 A
8/24/2012 37.26 38.01 37.2 37.85 2877300 37.55 A
8/27/2012 37.82 37.82 37.29 37.44 3058100 37.15 A
8/28/2012 37.38 37.46 36.9 36.95 4960600 36.66 A
8/29/2012 37.07 37.31 36.93 37.16 5025400 36.87 A
8/30/2012 36.96 37.23 36.91 37.04 2417900 36.75 A
8/31/2012 37.33 37.5 36.86 37.16 2296400 36.87 A
9/4/2012 36.97 37.47 36.71 37.05 3850000 36.76 A
9/5/2012 37.06 37.2 36.62 36.74 4073700 36.45 A
9/6/2012 37.11 37.54 36.71 37.48 4784400 37.19 A
9/7/2012 37.48 38.58 37.27 38.42 3991300 38.12 A
9/10/2012 38.32 38.73 38.04 38.26 2876700 37.96 A
9/11/2012 38.24 38.28 37.83 37.83 2928400 37.53 A
9/12/2012 37.92 38.22 37.49 37.49 4698800 37.2 A
9/13/2012 37.46 38.48 37.18 38.38 5386200 38.08 A
9/14/2012 38.44 40.14 38.4 39.73 6735100 39.42 A
9/17/2012 39.46 39.82 39.24 39.63 3646500 39.32 A
9/18/2012 39.56 39.86 39.45 39.55 3593900 39.24 A
9/19/2012 39.53 40.01 39.36 39.88 2948800 39.57 A
9/20/2012 39.55 39.75 38.77 39.23 4443300 38.92 A
9/21/2012 39.53 39.82 39 39 3525000 38.69 A
9/24/2012 38.87 39 38.37 38.69 2045900 38.39 A
9/25/2012 38.86 38.93 38.31 38.32 3543700 38.02 A
9/26/2012 38.48 38.48 37.88 38.27 3740000 37.97 A
9/27/2012 38.49 38.83 38.24 38.58 3414700 38.28 A
9/28/2012 38.48 38.62 37.8 38.45 4866500 38.25 A
10/1/2012 38.5 39.52 38.38 38.86 4222900 38.65 A
10/2/2012 39.08 39.39 38.54 38.87 3200300 38.66 A
10/3/2012 39 39.3 38.62 38.98 2503700 38.77 A
10/4/2012 39.22 39.64 38.87 39.2 5566500 38.99 A
10/5/2012 39.45 39.58 38.71 38.86 2798400 38.65 A
10/8/2012 38.59 38.91 38.5 38.66 2697000 38.46 A
10/9/2012 38.66 39.12 38.13 38.15 3041500 37.95 A
10/10/2012 38.18 38.24 37.22 37.41 3011700 37.21 A
10/11/2012 37.77 38.18 37.63 37.63 3006100 37.43 A
10/12/2012 37.69 37.78 37.12 37.22 2669300 37.02 A
10/15/2012 37.32 37.65 36.99 37.18 2645000 36.98 A
10/16/2012 37.47 37.98 37.45 37.91 2346500 37.71 A
10/17/2012 37.99 38.25 37.7 38.06 3862900 37.86 A
10/18/2012 37.59 37.6 36.45 36.64 6470200 36.45 A
10/19/2012 36.47 36.48 35.64 35.75 3989300 35.56 A
10/22/2012 35.66 36.1 35.53 36 2436900 35.81 A
10/23/2012 35.38 35.73 35.38 35.51 3298500 35.32 A
10/24/2012 35.64 35.97 35.44 35.85 4091200 35.66 A
10/25/2012 36.19 36.22 35.75 36.11 3289000 35.92 A
10/26/2012 36.17 36.3 35.7 35.94 3730500 35.75 A
10/31/2012 36 36.35 35.86 35.99 3416300 35.8 A
11/1/2012 36.04 37.15 35.95 37.1 3192400 36.9 A
11/2/2012 37.37 37.37 36.73 37 3351600 36.8 A
11/5/2012 37 37.71 36.85 37.61 2710600 37.41 A
11/6/2012 37.63 38.48 37.55 38.28 3725600 38.08 A
11/7/2012 37.78 37.92 37.24 37.58 3229800 37.38 A
11/8/2012 37.58 37.65 36.84 36.88 3062700 36.68 A
11/9/2012 36.63 37.15 36.56 36.91 3916400 36.71 A
11/12/2012 37.06 37.15 36.75 36.82 2073400 36.63 A
11/13/2012 36.66 36.85 36.29 36.33 3540600 36.14 A
11/14/2012 36.42 36.75 36.1 36.14 3169600 35.95 A
11/15/2012 36.14 36.64 35.69 35.75 5226100 35.56 A
11/16/2012 35.79 35.85 35.45 35.81 6603100 35.62 A
11/19/2012 37.01 37.98 37.01 37.51 5121200 37.31 A
11/20/2012 35.94 36.92 35.8 36.28 10520700 36.09 A
11/21/2012 36.32 36.47 35.64 35.84 4003900 35.65 A
11/23/2012 36.16 36.91 36.01 36.88 2246300 36.68 A
11/26/2012 36.69 37.47 36.59 37.47 3283000 37.27 A
11/27/2012 37.36 37.65 36.98 37.34 3435400 37.14 A
11/28/2012 37.12 38.02 36.93 37.97 3454000 37.77 A


Help would be greatly appreciated. Files attached.

Thanks!

Mike