T
tangomj
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?
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?