Column B = Names
Column c = Product Codes
Column D = Product Names

Cell H1 = "Product Code"

Cell I1 = Output Exact Name : =IF($H1=0, "", (IF(ISNA(VLOOKUP($H1, $B$3:$D$274, 1, FALSE)), "Not Found", VLOOKUP($H1, $B$3:$D$274, 1, FALSE))))

Cell J1 = Output Exact Product Name : =IF($H1=0, "", (IF(ISNA(VLOOKUP($H1, $B$3:$D$274, 3, FALSE)), "Not Found", VLOOKUP($H1, $B$3:$D$274, 3, FALSE))))

Formula works fine when I have a two column table array but it fails when using a three (3) column table arrary. Output is always "Not Found".

Working two table array formula:
=IF(J9=0, "", (IF(ISNA(VLOOKUP($H1, $C$3:$D$274, 2, FALSE)), "Not Found", VLOOKUP($H1, $C$3:$D$274, 2, FALSE))))

How do I resolve the three table array problem?