vlookup function in excel for column value matching
Row# 2 and column A showed the match results for Column B Row# 1 as you can see value 1 is matched against Column C records.
Row# 4 and column A showed no match results for Column B Row# 4 as you can see value 5A is not matched against Column C records.
so the code sample you need to use for the record range of 11 rows, as below
=IF(ISNA(VLOOKUP(B2, $C$2:$C$11, 2, FALSE )), “MISSING”, “MATCHED!”)
=IF(ISNA(VLOOKUP(B3, $C$2:$C$11, 2, FALSE )), “MISSING”, “MATCHED!”)
etc
