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

[jonathan92591]

--
Excel version:	Excel 2016
Computer operating system:	Windows 7
Sample data:	Sheet4 * A B C D 1 Name Food LookUpTable Servings 2 Bob Hamburger BobHamburger 2 3 Mary Salad MarySalad 3 4 Joe Hotdogs BobHamburger 4 5 Mike Cake JoeHotdogs 3 6 John Water MikeCake 2 7 * * MarySalad 6 <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> </tbody> Excel tables to the web >> Excel Jeanie HTML 4
Formulas/functions being used:	I have tried versions of Vlookup and Index with Match.
Desired Output:	Sheet4 * F G 1 Output 1 Output 2 2 BobHamburger 2 3 BobHamburger 4 4 MarySalad 3 5 MarySalad 6 6 JoeHotdogs 3 7 MikeCake 2 8 JohnWater 0 <colgroup><col style="font-weight:bold; width:30px; "><col style="width:101px;"><col style="width:64px;"></colgroup><tbody> </tbody> Excel tables to the web >> Excel Jeanie HTML 4
My goal:	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.
Error message:	N/A
How error occurred:	N/A
Generated in:	Excel
Thank you, JT

<tbody>
</tbody>

 

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