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>
</tbody>
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
Date | Values to match | Select Dates | Values to Select | if "Select Dates" are equal to "Date" then matching values in "Values to Select" Rows bring to same row as Date values | ||||||||||||||||||||||||
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC |
7/8/19 | 46 | 49 | 69 | 7/9/19 | 7/11/19 | 7/17/19 | 7/13/19 | 7/15/19 | 7/21/19 | 13 | 19 | 39 | 15 | 18 | 58 | 46 | ||||||||||||
7/7/19 | 13 | 19 | 39 | 7/8/19 | 7/12/19 | 7/15/19 | 7/12/19 | 7/16/19 | 7/19/19 | 15 | 18 | 58 | 82 | 83 | 23 | 13 | ||||||||||||
7/6/19 | 15 | 18 | 58 | 7/14/19 | 7/8/19 | 7/9/19 | 7/18/19 | 7/12/19 | 7/13/19 | 47 | 47 | 77 | 53 | 55 | 35 | |||||||||||||
7/5/19 | 23 | 28 | 38 | 7/13/19 | 7/6/19 | 7/9/19 | 7/17/19 | 7/10/19 | 7/13/19 | 53 | 55 | 35 | 41 | 48 | 18 | |||||||||||||
7/4/19 | 14 | 18 | 48 | 7/11/19 | 7/13/19 | 7/10/19 | 7/15/19 | 7/17/19 | 7/14/19 | 53 | 55 | 35 | 41 | 48 | 18 | 14 | 18 | 48 | 18 | |||||||||
7/3/19 | 67 | 69 | 79 | 7/9/19 | 7/5/19 | 7/7/19 | 7/13/19 | 7/9/19 | 7/11/19 | 53 | 55 | 35 | 41 | 48 | 18 | |||||||||||||
7/2/19 | 24 | 26 | 46 | 7/5/19 | 7/9/19 | 7/10/19 | 7/9/19 | 7/13/19 | 7/14/19 | 43 | 49 | 39 | 47 | 47 | 77 | 46 | 24 | |||||||||||
7/1/19 | 37 | 38 | 78 | 7/9/19 | 7/4/19 | 7/8/19 | 7/13/19 | 7/8/19 | 7/12/19 | 14 | 16 | 46 | 18 | 13 | 83 | |||||||||||||
6/30/19 | 37 | 38 | 78 | 7/4/19 | 7/3/19 | 7/9/19 | 7/8/19 | 7/7/19 | 7/13/19 | 41 | 48 | 18 | 63 | 64 | 34 | |||||||||||||
6/29/19 | 34 | 39 | 49 | 7/3/19 | 7/6/19 | 7/6/19 | 7/7/19 | 7/10/19 | 7/10/19 | 63 | 64 | 34 | 78 | 70 | 80 | |||||||||||||
6/28/19 | 47 | 47 | 77 | 7/3/19 | 7/1/19 | 7/3/19 | 7/7/19 | 7/5/19 | 7/7/19 | 14 | 16 | 46 | 18 | 13 | 83 | |||||||||||||
6/27/19 | 35 | 35 | 55 | 7/1/19 | 6/28/19 | 7/5/19 | 7/5/19 | 7/2/19 | 7/9/19 | 14 | 16 | 46 | 18 | 13 | 83 | |||||||||||||
6/26/19 | 14 | 18 | 48 | 7/2/19 | 6/29/19 | 6/30/19 | 7/6/19 | 7/3/19 | 7/4/19 | 22 | 24 | 24 | 73 | 75 | 35 |
<tbody>
</tbody>
Last edited: