This question was asked in Vlookup for Comparison of Two Tables

Put the formula

Mamoon Ulhaq's image