This question was asked in Vlookup for Comparison of Two Tables

How to use this formula in comparision

's image