VBA code of vlookup with IF condition

[Saleem29]

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

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>