VLOOKUP - 3 Table Array

[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?

[Bob Phillips]

=IF($H1=0, "",IF(ISNA(VLOOKUP($H1, $C$3:$D$274, 2, FALSE)), "Not
Found",VLOOKUP($H1,$C$3:$D$274, 2, FALSE))


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"tangomj" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
>
> --
> tangomj
> ------------------------------------------------------------------------
> tangomj's Profile:
http://www.excelforum.com/member.php...o&userid=36314
> View this thread: http://www.excelforum.com/showthread...hreadid=567114
>