This question was asked in Vlookup for Comparison of Two Tables
How to comparison of two table by vlookup 
Harendra Singh's image