| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vary the vlookup array depending on the value in a cell | Excel Worksheet Functions | |||
| Finding a Value in First Column of Table with VLOOKUP? | Excel Discussion (Misc queries) | |||
| Creating Array from Pivot Table | Excel Worksheet Functions | |||
| vlookup fails on data from a pivot table | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
