Lookup using multiple criteria with column/row defined tables

[caniacbart]

Greetings and salutations oh great gurus of all things EXCEL!!

I need a formula to return a person's name with from the below example after using "CATEGORY" and "DIVISION" to quantify. For instance, if I enter BEER and FLBU, I would expect it to return Paul Oderio as the name.

Any suggestions would be greatly appreciated!



[TABLE="width: 1431"]
<tbody>[TR]
[TD]CATEGORY[/TD]
[TD]BEER[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DIVISION[/TD]
[TD]FLBU[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PERSON'S NAME[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 12"] Divisions
[/TD]
[/TR]
[TR]
[TD]Categories
[/TD]
[TD]Arizona[/TD]
[TD]FLBU[/TD]
[TD]Great Lakes[/TD]
[TD]GCBU[/TD]
[TD]Heartland[/TD]
[TD]Midwest[/TD]
[TD]CCBU[/TD]
[TD]SEBU[/TD]
[TD]SWBU[/TD]
[TD]West[/TD]
[TD]WWF[/TD]
[/TR]
[TR]
[TD]Advertising[/TD]
[TD]Donna Humphrey[/TD]
[TD]Debbie Durfee[/TD]
[TD]Jessica Steinhoff[/TD]
[TD]Shawna Russ[/TD]
[TD]Tracia Clendenen[/TD]
[TD]Sherri Quintero[/TD]
[TD]Melanie Svinis[/TD]
[TD]Sarah Sawdon[/TD]
[TD]Mark Tate[/TD]
[TD]Heather Bailey with Lauren Van Hassel[/TD]
[TD]Jamie Skaggs[/TD]
[/TR]
[TR]
[TD]Alternative Snacks[/TD]
[TD]Jeremy Lawson[/TD]
[TD]Scott Lockard[/TD]
[TD]Kurt Fraschetti[/TD]
[TD]Cris Seebach[/TD]
[TD]Alison Miceli[/TD]
[TD]William Slattery[/TD]
[TD]Greg Smith[/TD]
[TD]Josh Mills[/TD]
[TD]Lali Dhillon[/TD]
[TD]Tom Ives[/TD]
[TD]Jeff Dunn[/TD]
[/TR]
[TR]
[TD]Automotive Products[/TD]
[TD]Donna Humphrey[/TD]
[TD]Scott Lockard[/TD]
[TD]AJ Weiss[/TD]
[TD]Cris Seebach[/TD]
[TD]Mohammad Ahmad[/TD]
[TD]Garry Carter[/TD]
[TD]Greg Smith[/TD]
[TD]Josh Mills[/TD]
[TD]Lali Dhillon[/TD]
[TD]Tom Ives[/TD]
[TD]David Rees[/TD]
[/TR]
[TR]
[TD]Baked Goods[/TD]
[TD]Eddie Blanco[/TD]
[TD]Max Gleason[/TD]
[TD]Julie Sisil
[/TD]
[TD]Craig Wells[/TD]
[TD]Tim Lukoski[/TD]
[TD]Billy Colemire[/TD]
[TD]Whitney Melchiorre[/TD]
[TD]Wayne Cox[/TD]
[TD]Gina Bailey[/TD]
[TD]Denny Sharma[/TD]
[TD]David Rees[/TD]
[/TR]
[TR]
[TD]Beer[/TD]
[TD]Leona Burke[/TD]
[TD]Paul Oderio[/TD]
[TD]Jack Wiolland[/TD]
[TD]Sondra Wilhite[/TD]
[TD]Jon Kuehnhold[/TD]
[TD]Tony McDaniel[/TD]
[TD]Bob Gulley[/TD]
[TD]Harvey Collins[/TD]
[TD]Mark Tate[/TD]
[TD]Mark Wright[/TD]
[TD]David Rees[/TD]
[/TR]
[TR]
[TD]Car Wash[/TD]
[TD]Al Wilkinson[/TD]
[TD]Paul Oderio[/TD]
[TD]Clint Blunier[/TD]
[TD]Josh Swinford[/TD]
[TD]Ed VanEtten[/TD]
[TD]Tony McDaniel[/TD]
[TD]Bob Gulley[/TD]
[TD]Robin Vaughn[/TD]
[TD]Bill Dinaro[/TD]
[TD]Mark Wright[/TD]
[TD]David Rees[/TD]
[/TR]
[TR]
[TD]Cigarettes[/TD]
[TD]Steve Malizio[/TD]
[TD]Georgia Tilman[/TD]
[TD]Tad Menoes[/TD]
[TD]Bob Richardson[/TD]
[TD]Kraig Knudsen[/TD]
[TD]Matt Hieb[/TD]
[TD]Kevin Walker[/TD]
[TD]Michael Flitcraft[/TD]
[TD]John Reitzel[/TD]
[TD]Ryan Clemmer[/TD]
[TD]Lee Maxwell[/TD]
[/TR]
[TR]
[TD]Coffee[/TD]
[TD]Jerry Anderson[/TD]
[TD]Max Gleason[/TD]
[TD]AJ Weiss[/TD]
[TD]Craig Wells[/TD]
[TD]Tim Lukoski[/TD]
[TD]Tim Caddell[/TD]
[TD]Jason Murray[/TD]
[TD]Wayne Cox[/TD]
[TD]Akins Macaulay[/TD]
[TD]Denny Sharma[/TD]
[TD]Jeff Dunn[/TD]
[/TR]
[TR]
[TD]Cold Displensed[/TD]
[TD]Jerry Anderson[/TD]
[TD]Max Gleason[/TD]
[TD]AJ Weiss[/TD]
[TD]Craig Wells[/TD]
[TD]Shane Veal[/TD]
[TD]Tim Caddell[/TD]
[TD]Jason Murray[/TD]
[TD]Wayne Cox[/TD]
[TD]Akins Macaulay[/TD]
[TD]Denny Sharma[/TD]
[TD]Jeff Dunn[/TD]
[/TR]
[TR]
[TD]Commissary Other Packaged Products[/TD]
[TD]Jeannine Petersen[/TD]
[TD]Debbie Durfee[/TD]
[TD]Julie Sisil[/TD]
[TD]Craig Wells[/TD]
[TD]Tim Lukoski[/TD]
[TD]Billy Colemire[/TD]
[TD]Jason Murray[/TD]
[TD]Wayne Cox[/TD]
[TD]Gina Bailey[/TD]
[TD]Deborah Katkus[/TD]
[TD]David Rees[/TD]
[/TR]
[TR]
[TD]Confectionary[/TD]
[TD]Jeremy Lawson[/TD]
[TD]Scott Lockard[/TD]
[TD]Kurt Fraschetti[/TD]
[TD]Cris Seebach[/TD]
[TD]Alison Miceli[/TD]
[TD]William Slattery[/TD]
[TD]Greg Smith[/TD]
[TD]Josh Mills[/TD]
[TD]Lali Dhillon[/TD]
[TD]Tom Ives[/TD]
[TD]Jeff Dunn[/TD]
[/TR]
[TR]
[TD]Dairy[/TD]
[TD]Ray Feeler[/TD]
[TD]Ron Ashley[/TD]
[TD]Jason Sklarek[/TD]
[TD]Brad Eaton[/TD]
[TD]Mohammad Ahmad[/TD]
[TD]Tony McDaniel[/TD]
[TD]Angela Bilanzich[/TD]
[TD]Misti Mason[/TD]
[TD]Cody Clark[/TD]
[TD]Tom Ives[/TD]
[TD]David Rees[/TD]
[/TR]
[TR]
[TD]Financial Services[/TD]
[TD]Al Wilkinson[/TD]
[TD]Ron Ashley[/TD]
[TD]Clint Blunier[/TD]
[TD]Shawna Russ[/TD]
[TD]Ruben Ornelas[/TD]
[TD]Tony McDaniel[/TD]
[TD]Bob Gulley[/TD]
[TD]Robin Vaughn[/TD]
[TD]Bill Dinaro[/TD]
[TD]Mark Wright[/TD]
[TD]Jeff Dunn[/TD]
[/TR]
[TR]
[TD]Frozen Dispensed[/TD]
[TD]Jerry Anderson[/TD]
[TD]Max Gleason[/TD]
[TD]AJ Weiss[/TD]
[TD]Craig Wells[/TD]
[TD]Shane Veal[/TD]
[TD]Tim Caddell[/TD]
[TD]Jason Murray[/TD]
[TD]Wayne Cox[/TD]
[TD]Akins Macaulay[/TD]
[TD]Denny Sharma[/TD]
[TD]Jeff Dunn[/TD]
[/TR]
[TR]
[TD]Frozen Foods[/TD]
[TD]Jeannine Petersen[/TD]
[TD]Debbie Durfee[/TD]
[TD]AJ Weiss[/TD]
[TD]Craig Wells[/TD]
[TD]Alison Miceli[/TD]
[TD]Garry Carter[/TD]
[TD]Melanie Svinis[/TD]
[TD]Josh Mills[/TD]
[TD]Lali Dhillon[/TD]
[TD]Leo Lopez[/TD]
[TD]David Rees[/TD]
[/TR]
[TR]
[TD]FS Prep on Site[/TD]
[TD]Jeannine Petersen[/TD]
[TD]Debbie Durfee[/TD]
[TD]Jeff Hanning-New England/Julie Sisil- Western-Half of BU[/TD]
[TD]Craig Wells[/TD]
[TD]Tim Lukoski[/TD]
[TD]Billy Colemire[/TD]
[TD]Whitney Melchiorre[/TD]
[TD]Wayne Cox[/TD]
[TD]Gina Bailey[/TD]
[TD]Deborah Katkus / Denny Sharma / Raquel Lopez[/TD]
[TD]David Rees[/TD]
[/TR]
[TR]
[TD]General Merchandise[/TD]
[TD]Joel Konichke[/TD]
[TD]Scott Lockard[/TD]
[TD]Clint Blunier[/TD]
[TD]Cris Seebach[/TD]
[TD]Mohammad Ahmad[/TD]
[TD]Garry Carter[/TD]
[TD]Melanie Svinis[/TD]
[TD]Josh Mills[/TD]
[TD]Bill Dinaro / Chris Robinson[/TD]
[TD]Ryan Clemmer[/TD]
[TD]Lee Maxwell[/TD]
[/TR]
[TR]
[TD]Grocery[/TD]
[TD]Steve Malizio (Groc/Household)
Donna Humphrey (Pet)[/TD]
[TD]Scott Lockard[/TD]
[TD]AJ Weiss[/TD]
[TD]Cris Seebach[/TD]
[TD]Mohammad Ahmad[/TD]
[TD]Garry Carter[/TD]
[TD]Greg Smith[/TD]
[TD]Josh Mills[/TD]
[TD]Lali Dhillon[/TD]
[TD]Leo Lopez[/TD]
[TD]David Rees[/TD]
[/TR]
</tbody>[/TABLE]

 

[t0azt]

=vlookup(b1,a6:l25,match(b2,a6:l6,0),0)

 

[Truiz]

Hi,

Take a look at this article:
https://exceljet.net/formula/two-way-lookup-with-index-and-match

Try it out if you need assistance or don't quite understand what the are talking about let me know.