Need to generate output into two columns using Vlookup or Index with Match formulas

[jonathan92591]

[TABLE="width: 1341"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]--[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Excel version:[/TD]
[TD]Excel 2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Computer operating system:[/TD]
[TD]Windows 7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sample data:[/TD]
[TD]Sheet4

*	A	B	C	D
Name	Food	LookUpTable	Servings
Bob	Hamburger	BobHamburger
Mary	Salad	MarySalad
Joe	Hotdogs	BobHamburger
Mike	Cake	JoeHotdogs
John	Water	MikeCake
*	*	MarySalad

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:76px;"><col style="width:101px;"><col style="width:59px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="align: right"]6[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Formulas/functions being used:[/TD]
[TD]I have tried versions of Vlookup and Index with Match.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Desired Output:[/TD]
[TD]Sheet4

*	F	G
Output 1	Output 2
BobHamburger
BobHamburger
MarySalad
MarySalad
JoeHotdogs
MikeCake
JohnWater

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:101px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="align: right"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="align: right"]6[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="align: right"]0[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]My goal:[/TD]
[TD]1: Search using concatenated column A and column B.
2: Search lookuptable column C.
3: Output in two columns, first column has concatenated columb A and column B, second column has column D data.
4: For examples where concatenated column A and columb B are not found, return a zero.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Error message:[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]How error occurred:[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Generated in:[/TD]
[TD]Excel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thank you, JT[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jonathan92591]

Hi all - My goal is to concatenate columns A and B. This gives me the lookup ID. Then using the combined lookup ID search the table/column C. Every time there is a match, it is listed along with column D data. For IDs that cannot be found in the table/column C, then return the ID name and a zero.