Hi,
I have an excel template in which I need to apply the VBA code for Vlookup with IF condition. If the codes in Book A & Book B matches then in the "New Date" column in Book A should be updated as per "Prior Date" from Book B. If its shows #N/A then the same date should be updated in the New date column.
Like in this case: Book A: The New date and date should be same because the Code B is not there in the Book B.
Book A
<tbody>
</tbody><colgroup><col><col><col></colgroup>
Book B
<tbody>
</tbody><colgroup><col><col></colgroup>
Thanks
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I have an excel template in which I need to apply the VBA code for Vlookup with IF condition. If the codes in Book A & Book B matches then in the "New Date" column in Book A should be updated as per "Prior Date" from Book B. If its shows #N/A then the same date should be updated in the New date column.
Like in this case: Book A: The New date and date should be same because the Code B is not there in the Book B.
Book A
Code | Date | New Date |
A | 1/1/2016 | 12/12/2016 |
B | 2/3/2016 | #N/A |
C | 5/4/2016 | 4/6/2016 |
D | 9/10/2016 | 3/5/2016 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>
Book B
Code | Prior Date |
A | 12/12/2016 |
C | 4/6/2016 |
D | 3/5/2016 |
G | 4/5/2016 |
<tbody>
</tbody><colgroup><col><col></colgroup>
Thanks
<tbody>
</tbody><colgroup><col><col><col></colgroup>