RosieG1991
New Member
- Joined
- Feb 23, 2017
- Messages
- 21
I've tried a selection of formulas, mostly trying VLookups and IF statements to pull the information I need but I don't seem to be getting the result I want.
I'm trying do the following:
I want to pull the highlighted date in Table 2 (keeping in mind table 2 is on another sheet in my Workbook) into the Date column in Table 1 for A. I thought about specifying the text in column 2 of Table 2 in the formula?
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Happy to provide more information if needed.
Any help is much appreciated!!
Cheers
R
I'm trying do the following:
I want to pull the highlighted date in Table 2 (keeping in mind table 2 is on another sheet in my Workbook) into the Date column in Table 1 for A. I thought about specifying the text in column 2 of Table 2 in the formula?
Table 1
ID | Date |
A | |
B | |
C | |
D |
<tbody>
</tbody>
Table 2
ID | Month | Date |
A | Jan | 1/01/2018 |
A | Feb | 2/02/2018 |
A | Mar | 3/03/2018 |
A | Apr | 4/04/2018 |
A | May | 5/05/2018 |
B | Jan | 11/01/2018 |
B | Feb | 12/02/2018 |
B | Mar | 13/03/2018 |
B | Apr | 14/04/2018 |
B | May | 15/05/2018 |
C | Jan | 21/01/2018 |
C | Feb | 22/02/2018 |
C | Mar | 23/03/2018 |
C | Apr | 24/04/2018 |
C | May | 25/05/2018 |
<tbody>
</tbody>
Happy to provide more information if needed.
Any help is much appreciated!!
Cheers
R