VLOOKUP - 3 Table Array
 

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

VLOOKUP - 3 Table Array
 

=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" wrote in
message ...

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