match dates then move values to corresponding cells

LuGyver

Board Regular
Joined
Mar 13, 2014
Messages
88
Office Version
  1. 2007
Platform
  1. Windows
To make this more visible here's a link to access the file
What I need is A formula in columns U1:AC13 which will match the Dates in Column A with Select Dates in Columns G-L and then bring the corresponding Select Value (if any) in columns N-S and place them in the same line as the "Date" the Select Values matched.
I manually placed the results I want to see into U1:AC13 (hope no mistakes).

Thanks for your Possible assistance


<tbody>
[TD="class: xl106, align: center"]Date[/TD]
[TD="class: xl82, width: 24, align: center"][/TD]
[TD="class: xl110, width: 141, colspan: 3, align: center"]Values to match[/TD]
[TD="class: xl81, width: 23, align: center"][/TD]
[TD="class: xl107, width: 384, colspan: 6, align: center"]Select Dates[/TD]
[TD="class: xl82, width: 21, align: center"][/TD]
[TD="class: xl110, width: 384, colspan: 6, align: center"]Values to Select[/TD]
[TD="class: xl81, width: 29, align: center"][/TD]
[TD="class: xl113, width: 360, colspan: 9, align: center"]if "Select Dates" are equal to "Date" then matching values in "Values to Select" Rows bring to same row as Date values[/TD]

[TD="class: xl83, align: center"]A[/TD]
[TD="class: xl82, align: center"]B[/TD]
[TD="class: xl86, align: center"]C[/TD]
[TD="class: xl86, align: center"]D[/TD]
[TD="class: xl86, align: center"]E[/TD]
[TD="class: xl81, align: center"]F[/TD]
[TD="class: xl82, align: center"]G[/TD]
[TD="class: xl82, align: center"]H[/TD]
[TD="class: xl82, align: center"]I[/TD]
[TD="class: xl82, align: center"]J[/TD]
[TD="class: xl82, align: center"]K[/TD]
[TD="class: xl82, align: center"]L[/TD]
[TD="class: xl82, align: center"]M[/TD]
[TD="class: xl81, align: center"]N[/TD]
[TD="class: xl81, align: center"]O[/TD]
[TD="class: xl81, align: center"]P[/TD]
[TD="class: xl81, align: center"]Q[/TD]
[TD="class: xl81, align: center"]R[/TD]
[TD="class: xl81, align: center"]S[/TD]
[TD="class: xl81, align: center"]T[/TD]
[TD="class: xl92, align: center"]U[/TD]
[TD="class: xl92, align: center"]V[/TD]
[TD="class: xl92, align: center"]W[/TD]
[TD="class: xl92, align: center"]X[/TD]
[TD="class: xl92, align: center"]Y[/TD]
[TD="class: xl92, align: center"]Z[/TD]
[TD="class: xl81, align: center"]AA[/TD]
[TD="class: xl84, align: center"]AB[/TD]
[TD="class: xl84, align: center"]AC[/TD]

[TD="class: xl83, align: center"] 7/8/19
[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl86, align: center"] 46 [/TD]
[TD="class: xl86, align: center"] 49 [/TD]
[TD="class: xl86, align: center"] 69 [/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl82, align: center"]7/11/19[/TD]
[TD="class: xl82, align: center"]7/17/19[/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl82, align: center"]7/15/19[/TD]
[TD="class: xl82, align: center"]7/21/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl81, align: center"]13[/TD]
[TD="class: xl81, align: center"]19[/TD]
[TD="class: xl81, align: center"]39[/TD]
[TD="class: xl81, align: center"]15[/TD]
[TD="class: xl81, align: center"]18[/TD]
[TD="class: xl81, align: center"]58[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl92, align: center"] 46 [/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl92, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl84, align: center"][/TD]
[TD="class: xl84, align: center"][/TD]

[TD="class: xl87, align: center"] 7/7/19
[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl88, align: center"] 13 [/TD]
[TD="class: xl88, align: center"] 19 [/TD]
[TD="class: xl88, align: center"] 39 [/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl83, align: center"]7/8/19[/TD]
[TD="class: xl82, align: center"]7/12/19[/TD]
[TD="class: xl82, align: center"]7/15/19[/TD]
[TD="class: xl82, align: center"]7/12/19[/TD]
[TD="class: xl82, align: center"]7/16/19[/TD]
[TD="class: xl82, align: center"]7/19/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl86, align: center"]15[/TD]
[TD="class: xl86, align: center"]18[/TD]
[TD="class: xl86, align: center"]58[/TD]
[TD="class: xl86, align: center"]82[/TD]
[TD="class: xl86, align: center"]83[/TD]
[TD="class: xl86, align: center"]23[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl88, align: center"] 13 [/TD]
[TD="class: xl88, align: center"][/TD]
[TD="class: xl88, align: center"][/TD]
[TD="class: xl88, align: center"][/TD]
[TD="class: xl88, align: center"][/TD]
[TD="class: xl88, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl89, align: center"]7/6/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl90, align: center"]15[/TD]
[TD="class: xl90, align: center"]18[/TD]
[TD="class: xl90, align: center"]58[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl82, align: center"]7/14/19[/TD]
[TD="class: xl83, align: center"]7/8/19[/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl82, align: center"]7/18/19[/TD]
[TD="class: xl82, align: center"]7/12/19[/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl86, align: center"]47[/TD]
[TD="class: xl86, align: center"]47[/TD]
[TD="class: xl86, align: center"]77[/TD]
[TD="class: xl86, align: center"]53[/TD]
[TD="class: xl86, align: center"]55[/TD]
[TD="class: xl86, align: center"]35[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl90, align: center"][/TD]
[TD="class: xl90, align: center"][/TD]
[TD="class: xl90, align: center"][/TD]
[TD="class: xl90, align: center"][/TD]
[TD="class: xl90, align: center"][/TD]
[TD="class: xl90, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl93, align: center"] 7/5/19
[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl94, align: center"] 23
[/TD]
[TD="class: xl94, align: center"] 28
[/TD]
[TD="class: xl94, align: center"] 38 [/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl89, align: center"]7/6/19[/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl82, align: center"]7/17/19[/TD]
[TD="class: xl82, align: center"]7/10/19[/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl90, align: center"]53[/TD]
[TD="class: xl90, align: center"]55[/TD]
[TD="class: xl90, align: center"]35[/TD]
[TD="class: xl90, align: center"]41[/TD]
[TD="class: xl90, align: center"]48[/TD]
[TD="class: xl90, align: center"]18[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl94, align: center"][/TD]
[TD="class: xl94, align: center"][/TD]
[TD="class: xl94, align: center"][/TD]
[TD="class: xl94, align: center"][/TD]
[TD="class: xl94, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl95, align: center"]7/4/19[/TD]
[TD="class: xl95, align: center"][/TD]
[TD="class: xl84, align: center"]14[/TD]
[TD="class: xl84, align: center"]18[/TD]
[TD="class: xl84, align: center"]48[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl82, align: center"]7/11/19[/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl82, align: center"]7/10/19[/TD]
[TD="class: xl82, align: center"]7/15/19[/TD]
[TD="class: xl82, align: center"]7/17/19[/TD]
[TD="class: xl82, align: center"]7/14/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl81, align: center"]53[/TD]
[TD="class: xl81, align: center"]55[/TD]
[TD="class: xl81, align: center"]35[/TD]
[TD="class: xl81, align: center"]41[/TD]
[TD="class: xl81, align: center"]48[/TD]
[TD="class: xl81, align: center"]18[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl84, align: center"] 14
[/TD]
[TD="class: xl84, align: center"] 18 [/TD]
[TD="class: xl84, align: center"] 48 [/TD]
[TD="class: xl84, align: center"] 18 [/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl102, align: center"]7/3/19[/TD]
[TD="class: xl103, align: center"][/TD]
[TD="class: xl104, align: center"]67[/TD]
[TD="class: xl104, align: center"]69[/TD]
[TD="class: xl104, align: center"]79[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl82, align: center"] 7/5/19 [/TD]
[TD="class: xl87, align: center"]7/7/19[/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl82, align: center"]7/11/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl88, align: center"]53[/TD]
[TD="class: xl88, align: center"]55[/TD]
[TD="class: xl88, align: center"]35[/TD]
[TD="class: xl88, align: center"]41[/TD]
[TD="class: xl88, align: center"] 48 [/TD]
[TD="class: xl88, align: center"]18[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl105, align: center"][/TD]
[TD="class: xl105, align: center"][/TD]
[TD="class: xl105, align: center"][/TD]
[TD="class: xl105, align: center"][/TD]
[TD="class: xl105, align: center"][/TD]
[TD="class: xl105, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl98, align: center"]7/2/19[/TD]
[TD="class: xl98, align: center"][/TD]
[TD="class: xl99, align: center"]24[/TD]
[TD="class: xl99, align: center"]26[/TD]
[TD="class: xl99, align: center"]46[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl93, align: center"]7/5/19[/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl82, align: center"]7/10/19[/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl82, align: center"]7/14/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl94, align: center"]43[/TD]
[TD="class: xl94, align: center"]49[/TD]
[TD="class: xl94, align: center"]39[/TD]
[TD="class: xl94, align: center"]47[/TD]
[TD="class: xl94, align: center"]47[/TD]
[TD="class: xl94, align: center"]77[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl99, align: center"] 46 [/TD]
[TD="class: xl99, align: center"] 24 [/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl100, align: center"]7/1/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl101, align: center"]37[/TD]
[TD="class: xl101, align: center"]38[/TD]
[TD="class: xl101, align: center"]78[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl96, align: center"]7/4/19[/TD]
[TD="class: xl83, align: center"] 7/8/19 [/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl83, align: center"]7/8/19[/TD]
[TD="class: xl82, align: center"]7/12/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl85, align: center"]14[/TD]
[TD="class: xl85, align: center"]16[/TD]
[TD="class: xl85, align: center"] 46 [/TD]
[TD="class: xl85, align: center"]18[/TD]
[TD="class: xl85, align: center"]13[/TD]
[TD="class: xl85, align: center"]83[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl101, align: center"][/TD]
[TD="class: xl101, align: center"][/TD]
[TD="class: xl101, align: center"][/TD]
[TD="class: xl101, align: center"][/TD]
[TD="class: xl101, align: center"][/TD]
[TD="class: xl101, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl82, align: center"]6/30/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl81, align: center"]37[/TD]
[TD="class: xl81, align: center"]38[/TD]
[TD="class: xl81, align: center"]78[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl96, align: center"]7/4/19[/TD]
[TD="class: xl102, align: center"]7/3/19[/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl83, align: center"]7/8/19[/TD]
[TD="class: xl87, align: center"]7/7/19[/TD]
[TD="class: xl82, align: center"]7/13/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl85, align: center"]41[/TD]
[TD="class: xl85, align: center"]48[/TD]
[TD="class: xl85, align: center"]18[/TD]
[TD="class: xl85, align: center"]63[/TD]
[TD="class: xl85, align: center"]64[/TD]
[TD="class: xl85, align: center"]34[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl82, align: center"]6/29/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl81, align: center"]34[/TD]
[TD="class: xl81, align: center"]39[/TD]
[TD="class: xl81, align: center"]49[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl102, align: center"]7/3/19[/TD]
[TD="class: xl89, align: center"]7/6/19[/TD]
[TD="class: xl89, align: center"]7/6/19[/TD]
[TD="class: xl87, align: center"]7/7/19[/TD]
[TD="class: xl82, align: center"]7/10/19[/TD]
[TD="class: xl82, align: center"]7/10/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl91, align: center"]63[/TD]
[TD="class: xl91, align: center"]64[/TD]
[TD="class: xl91, align: center"]34[/TD]
[TD="class: xl91, align: center"]78[/TD]
[TD="class: xl91, align: center"]70[/TD]
[TD="class: xl91, align: center"]80[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl82, align: center"]6/28/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl81, align: center"]47[/TD]
[TD="class: xl81, align: center"]47[/TD]
[TD="class: xl81, align: center"]77[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl102, align: center"]7/3/19[/TD]
[TD="class: xl100, align: center"]7/1/19[/TD]
[TD="class: xl102, align: center"]7/3/19[/TD]
[TD="class: xl87, align: center"] 7/7/19 [/TD]
[TD="class: xl93, align: center"] 7/5/19 [/TD]
[TD="class: xl87, align: center"]7/7/19[/TD]
[TD="class: xl87, align: center"][/TD]
[TD="class: xl88, align: center"] 14 [/TD]
[TD="class: xl88, align: center"]16[/TD]
[TD="class: xl88, align: center"]46[/TD]
[TD="class: xl88, align: center"] 18 [/TD]
[TD="class: xl88, align: center"] 13 [/TD]
[TD="class: xl88, align: center"]83[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl82, align: center"]6/27/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl81, align: center"]35[/TD]
[TD="class: xl81, align: center"]35[/TD]
[TD="class: xl81, align: center"]55[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl100, align: center"]7/1/19[/TD]
[TD="class: xl82, align: center"]6/28/19[/TD]
[TD="class: xl93, align: center"]7/5/19[/TD]
[TD="class: xl82, align: center"]7/5/19[/TD]
[TD="class: xl98, align: center"]7/2/19[/TD]
[TD="class: xl82, align: center"]7/9/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl94, align: center"]14[/TD]
[TD="class: xl94, align: center"]16[/TD]
[TD="class: xl94, align: center"]46[/TD]
[TD="class: xl94, align: center"]18[/TD]
[TD="class: xl94, align: center"]13[/TD]
[TD="class: xl94, align: center"]83[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

[TD="class: xl82, align: center"]6/26/19[/TD]
[TD="class: xl82, align: center"][/TD]
[TD="class: xl81, align: center"]14[/TD]
[TD="class: xl81, align: center"]18[/TD]
[TD="class: xl81, align: center"]48[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl98, align: center"]7/2/19[/TD]
[TD="class: xl82, align: center"]6/29/19[/TD]
[TD="class: xl82, align: center"]6/30/19[/TD]
[TD="class: xl89, align: center"]7/6/19[/TD]
[TD="class: xl102, align: center"]7/3/19[/TD]
[TD="class: xl96, align: center"]7/4/19[/TD]
[TD="class: xl96, align: center"][/TD]
[TD="class: xl97, align: center"]22[/TD]
[TD="class: xl97, align: center"]24[/TD]
[TD="class: xl97, align: center"]24[/TD]
[TD="class: xl97, align: center"]73[/TD]
[TD="class: xl97, align: center"]75[/TD]
[TD="class: xl97, align: center"]35[/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]
[TD="class: xl81, align: center"][/TD]

</tbody>
 
Last edited:

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top