FlexYourData
New Member
- Joined
- Jun 28, 2016
- Messages
- 4
Hello! I am trying to use the Index Match functions to carry over data from one sheet to another. I am a little lost as to how to make this work, so I am not sure if what I have is on the right track.
Goal:
In the sheet titled 3.Summary (first screen shot below) the formula in cell D2 is trying to bring over the date from column J or L within sheet 2.Timeline (second screens shot below). The value used to match between the two sheets is a concatenation of ID (column B) and Start date (column C). The value that should appear in cell D2 is 4/10/14 and the value that should appear in E2 is 6/1/15.
3.Summary:
<tbody>
</tbody>2.Timeline:
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
Any help you can provide is greatly appreciate! Thank you!
Goal:
In the sheet titled 3.Summary (first screen shot below) the formula in cell D2 is trying to bring over the date from column J or L within sheet 2.Timeline (second screens shot below). The value used to match between the two sheets is a concatenation of ID (column B) and Start date (column C). The value that should appear in cell D2 is 4/10/14 and the value that should appear in E2 is 6/1/15.
3.Summary:
Excel 2012
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead> </thead><tbody> </tbody> 3.Summary
<tbody> </tbody> |
<tbody>
</tbody>
Excel 2012
B | C | D | E | F | G | H | I | J | K | L | M | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ID (Auto-fill) | Start Date (Auto-fill) | Step 1 (mandatory) | Step 2 (mandatory) | Step 3 (mandatory) | Step 4 | Step 5 | |||||
2 | Example | 3/20/2014 | 3/20/14 | 0 | 3/25/14 | 5 | 3/25/14 | 5 | ### | 4/10/14 | 21 | |
3 | Example 2 | 4/11/2015 | 4/15/15 | 4 | 4/30/15 | 19 | 5/18/15 | 37 | 6/1/15 | 51 | ### | |
4 | Example 3 | 1/0/1900 | 0 | 0 | 0 | 0 | 0 | |||||
5 | Example 4 | 1/0/1900 | 0 | 0 | 0 | 0 | 0 | |||||
6 | Example 5 | 1/0/1900 | 0 | 0 | 0 | 0 | 0 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
2.Timeline
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
Any help you can provide is greatly appreciate! Thank you!