[TABLE="class: grid, width: 442"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Company[/TD]
[TD]Contact[/TD]
[TD][/TD]
[TD]Company[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3M[/TD]
[TD]Amina Zimmerman
[/TD]
[TD][/TD]
[TD]3M[/TD]
[TD]Tamara Phillips
[/TD]
[/TR]
[TR]
[TD]Adidas[/TD]
[TD]Cayden Myers
[/TD]
[TD][/TD]
[TD]Adidas[/TD]
[TD]Naima Cisneros
[/TD]
[/TR]
[TR]
[TD]Adobe Systems[/TD]
[TD]Quinton Dunlap
[/TD]
[TD][/TD]
[TD]Adobe Systems[/TD]
[TD]Esther Cochran
[/TD]
[/TR]
[TR]
[TD]Apple Inc.[/TD]
[TD]Sarah French
[/TD]
[TD][/TD]
[TD]Apple Inc.[/TD]
[TD]Juliette Lucero
[/TD]
[/TR]
[TR]
[TD]Avon[/TD]
[TD]Mathew Simmons
[/TD]
[TD][/TD]
[TD]Avon[/TD]
[TD]Drake Knox
[/TD]
[/TR]
[TR]
[TD]Bank of America[/TD]
[TD]Juliette Lucero
[/TD]
[TD][/TD]
[TD]Bank of America[/TD]
[TD]Amina Zimmerman
[/TD]
[/TR]
[TR]
[TD]Beko[/TD]
[TD]Drake Knox
[/TD]
[TD][/TD]
[TD]Beko[/TD]
[TD]Cayden Myers
[/TD]
[/TR]
[TR]
[TD]BMW[/TD]
[TD]Roland Alexander
[/TD]
[TD][/TD]
[TD]BMW[/TD]
[TD]Quinton Dunlap
[/TD]
[/TR]
[TR]
[TD]Canon[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Canon[/TD]
[TD]Sarah French
[/TD]
[/TR]
[TR]
[TD]Cartier SA[/TD]
[TD]Tamara Phillips
[/TD]
[TD][/TD]
[TD]Cartier SA[/TD]
[TD]Maximo Yu
[/TD]
[/TR]
[TR]
[TD]Chase[/TD]
[TD]Naima Cisneros
[/TD]
[TD][/TD]
[TD]Chase[/TD]
[TD]Raelynn Mora
[/TD]
[/TR]
[TR]
[TD]Coca-Cola[/TD]
[TD]Esther Cochran
[/TD]
[TD][/TD]
[TD]Coca-Cola[/TD]
[TD]Marley Collins
[/TD]
[/TR]
[TR]
[TD]Corona[/TD]
[TD]Juliette Lucero
[/TD]
[TD][/TD]
[TD]Corona[/TD]
[TD]Drake Knox
[/TD]
[/TR]
[TR]
[TD]Facebook, Inc.[/TD]
[TD]Drake Knox
[/TD]
[TD][/TD]
[TD]Facebook, Inc.[/TD]
[TD]Roland Alexander
[/TD]
[/TR]
[TR]
[TD]Gap Inc.[/TD]
[TD]Amina Zimmerman
[/TD]
[TD][/TD]
[TD]Gap Inc.[/TD]
[TD]Leonardo Robbins
[/TD]
[/TR]
[TR]
[TD]General Electric[/TD]
[TD]Cayden Myers
[/TD]
[TD][/TD]
[TD]General Electric[/TD]
[TD]Tamara Phillips
[/TD]
[/TR]
[TR]
[TD]Global Gillette[/TD]
[TD]Quinton Dunlap
[/TD]
[TD][/TD]
[TD]Global Gillette[/TD]
[TD]Naima Cisneros
[/TD]
[/TR]
[TR]
[TD]Gucci[/TD]
[TD]Sarah French
[/TD]
[TD][/TD]
[TD]Gucci[/TD]
[TD]Jerimiah Case
[/TD]
[/TR]
[TR]
[TD]Heineken Brewery[/TD]
[TD]Maximo Yu
[/TD]
[TD][/TD]
[TD]Heineken Brewery[/TD]
[TD]Hayden Key
[/TD]
[/TR]
[TR]
[TD]Hermès[/TD]
[TD]Raelynn Mora
[/TD]
[TD][/TD]
[TD]Hermès[/TD]
[TD]Esther Cochran
[/TD]
[/TR]
[TR]
[TD]Hewlett-Packard[/TD]
[TD]Marley Collins
[/TD]
[TD][/TD]
[TD]Hewlett-Packard[/TD]
[TD]Gauge Petersen
[/TD]
[/TR]
[TR]
[TD]Honda Motor Company, Ltd[/TD]
[TD]Drake Knox
[/TD]
[TD][/TD]
[TD]Honda Motor Company, Ltd[/TD]
[TD]Mylee Mathis
[/TD]
[/TR]
[TR]
[TD]HSBC[/TD]
[TD]Roland Alexander
[/TD]
[TD][/TD]
[TD]HSBC[/TD]
[TD]Anna Steele
[/TD]
[/TR]
[TR]
[TD]Jack Daniel's[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Jack Daniel's[/TD]
[TD]Drake Knox
[/TD]
[/TR]
[TR]
[TD]Johnnie Walker[/TD]
[TD]Tamara Phillips
[/TD]
[TD][/TD]
[TD]Johnnie Walker[/TD]
[TD]Roland Alexander
[/TD]
[/TR]
[TR]
[TD]Johnson & Johnson[/TD]
[TD]Naima Cisneros
[/TD]
[TD][/TD]
[TD]Johnson & Johnson[/TD]
[TD]Leonardo Robbins
[/TD]
[/TR]
[TR]
[TD]KFC[/TD]
[TD]Jerimiah Case
[/TD]
[TD][/TD]
[TD]KFC[/TD]
[TD]Tamara Phillips
[/TD]
[/TR]
[TR]
[TD]Kia Motors[/TD]
[TD]Hayden Key
[/TD]
[TD][/TD]
[TD]Kia Motors[/TD]
[TD]Naima Cisneros
[/TD]
[/TR]
[TR]
[TD]Kleenex[/TD]
[TD]Esther Cochran
[/TD]
[TD][/TD]
[TD]Kleenex[/TD]
[TD]Esther Cochran
[/TD]
[/TR]
[TR]
[TD]Kleenex[/TD]
[TD]Paityn Larsen[/TD]
[TD][/TD]
[TD]L'Oréal[/TD]
[TD]Gauge Petersen
[/TD]
[/TR]
[TR]
[TD]L'Oréal[/TD]
[TD]Gauge Petersen
[/TD]
[TD][/TD]
[TD]Mercedes-Benz[/TD]
[TD]Mylee Mathis
[/TD]
[/TR]
[TR]
[TD]Mercedes-Benz[/TD]
[TD]Mylee Mathis
[/TD]
[TD][/TD]
[TD]Mitsubishi[/TD]
[TD]Anna Steele
[/TD]
[/TR]
[TR]
[TD]Mitsubishi[/TD]
[TD]Anna Steele
[/TD]
[TD][/TD]
[TD]Moët et Chandon[/TD]
[TD]Davian Foley
[/TD]
[/TR]
[TR]
[TD]Moët et Chandon[/TD]
[TD]Drake Knox
[/TD]
[TD][/TD]
[TD]MTV[/TD]
[TD]Anna Steele
[/TD]
[/TR]
[TR]
[TD]MTV[/TD]
[TD]Roland Alexander
[/TD]
[TD][/TD]
[TD]Nescafé[/TD]
[TD]Davian Foley
[/TD]
[/TR]
[TR]
[TD]Nescafé[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Nintendo[/TD]
[TD]Leonardo Robbins
[/TD]
[/TR]
[TR]
[TD]Nintendo[/TD]
[TD]Tamara Phillips
[/TD]
[TD][/TD]
[TD]Pampers[/TD]
[TD]Sarah French
[/TD]
[/TR]
[TR]
[TD]Pampers[/TD]
[TD]Naima Cisneros
[/TD]
[TD][/TD]
[TD]Panasonic Corporation[/TD]
[TD]Mathew Simmons
[/TD]
[/TR]
[TR]
[TD]Panasonic Corporation[/TD]
[TD]Esther Cochran
[/TD]
[TD][/TD]
[TD]PepsiCo[/TD]
[TD]Amina Zimmerman
[/TD]
[/TR]
[TR]
[TD]PepsiCo[/TD]
[TD]Gauge Petersen
[/TD]
[TD][/TD]
[TD]Prada[/TD]
[TD]Cayden Myers
[/TD]
[/TR]
[TR]
[TD]Prada[/TD]
[TD]Mylee Mathis
[/TD]
[TD][/TD]
[TD]Samsung Group[/TD]
[TD]Quinton Dunlap
[/TD]
[/TR]
[TR]
[TD]Samsung Group[/TD]
[TD]Anna Steele
[/TD]
[TD][/TD]
[TD]SAP[/TD]
[TD]Sarah French
[/TD]
[/TR]
[TR]
[TD]SAP[/TD]
[TD]Davian Foley
[/TD]
[TD][/TD]
[TD]Siemens AG[/TD]
[TD]Mathew Simmons
[/TD]
[/TR]
[TR]
[TD]Siemens AG[/TD]
[TD]Anna Steele
[/TD]
[TD][/TD]
[TD]The Walt Disney Company[/TD]
[TD]Juliette Lucero
[/TD]
[/TR]
[TR]
[TD]The Walt Disney Company[/TD]
[TD]Davian Foley
[/TD]
[TD][/TD]
[TD]Toyota Motor Corporation[/TD]
[TD]Drake Knox
[/TD]
[/TR]
[TR]
[TD]Toyota Motor Corporation[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Vodafone[/TD]
[TD]Roland Alexander
[/TD]
[/TR]
[TR]
[TD]Toyota Motor Corporation[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Wells Fargo[/TD]
[TD]Leonardo Robbins
[/TD]
[/TR]
[TR]
[TD]Toyota Motor Corporation[/TD]
[TD]Quinton Dunlap
[/TD]
[TD][/TD]
[TD]Wells Fargo[/TD]
[TD]Tamara Phillips
[/TD]
[/TR]
[TR]
[TD]Vodafone[/TD]
[TD]Sarah French
[/TD]
[TD][/TD]
[TD]Wells Fargo[/TD]
[TD]Naima Cisneros
[/TD]
[/TR]
[TR]
[TD]Wells Fargo[/TD]
[TD]Mathew Simmons
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I'm trying to do is check if a contact is associated with a certain company. The list on the left has correctly matches up a company with any contacts we have on record. The list on the right is of a contact requesting information on a company. I need to check that the contact in the right list is actually a contact for that company. For example:
Amina Zimmerman is a contact for 3M.
Tamara Phillips has requested information about 3M.
She is not associated with 3M in the left list so she would be denied.
Some of the companies have multiple contacts listed and some contacts are with multiple companies. A vlookup only returns the first instance. Is there anyway to check all contacts for a company?
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Company[/TD]
[TD]Contact[/TD]
[TD][/TD]
[TD]Company[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3M[/TD]
[TD]Amina Zimmerman
[/TD]
[TD][/TD]
[TD]3M[/TD]
[TD]Tamara Phillips
[/TD]
[/TR]
[TR]
[TD]Adidas[/TD]
[TD]Cayden Myers
[/TD]
[TD][/TD]
[TD]Adidas[/TD]
[TD]Naima Cisneros
[/TD]
[/TR]
[TR]
[TD]Adobe Systems[/TD]
[TD]Quinton Dunlap
[/TD]
[TD][/TD]
[TD]Adobe Systems[/TD]
[TD]Esther Cochran
[/TD]
[/TR]
[TR]
[TD]Apple Inc.[/TD]
[TD]Sarah French
[/TD]
[TD][/TD]
[TD]Apple Inc.[/TD]
[TD]Juliette Lucero
[/TD]
[/TR]
[TR]
[TD]Avon[/TD]
[TD]Mathew Simmons
[/TD]
[TD][/TD]
[TD]Avon[/TD]
[TD]Drake Knox
[/TD]
[/TR]
[TR]
[TD]Bank of America[/TD]
[TD]Juliette Lucero
[/TD]
[TD][/TD]
[TD]Bank of America[/TD]
[TD]Amina Zimmerman
[/TD]
[/TR]
[TR]
[TD]Beko[/TD]
[TD]Drake Knox
[/TD]
[TD][/TD]
[TD]Beko[/TD]
[TD]Cayden Myers
[/TD]
[/TR]
[TR]
[TD]BMW[/TD]
[TD]Roland Alexander
[/TD]
[TD][/TD]
[TD]BMW[/TD]
[TD]Quinton Dunlap
[/TD]
[/TR]
[TR]
[TD]Canon[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Canon[/TD]
[TD]Sarah French
[/TD]
[/TR]
[TR]
[TD]Cartier SA[/TD]
[TD]Tamara Phillips
[/TD]
[TD][/TD]
[TD]Cartier SA[/TD]
[TD]Maximo Yu
[/TD]
[/TR]
[TR]
[TD]Chase[/TD]
[TD]Naima Cisneros
[/TD]
[TD][/TD]
[TD]Chase[/TD]
[TD]Raelynn Mora
[/TD]
[/TR]
[TR]
[TD]Coca-Cola[/TD]
[TD]Esther Cochran
[/TD]
[TD][/TD]
[TD]Coca-Cola[/TD]
[TD]Marley Collins
[/TD]
[/TR]
[TR]
[TD]Corona[/TD]
[TD]Juliette Lucero
[/TD]
[TD][/TD]
[TD]Corona[/TD]
[TD]Drake Knox
[/TD]
[/TR]
[TR]
[TD]Facebook, Inc.[/TD]
[TD]Drake Knox
[/TD]
[TD][/TD]
[TD]Facebook, Inc.[/TD]
[TD]Roland Alexander
[/TD]
[/TR]
[TR]
[TD]Gap Inc.[/TD]
[TD]Amina Zimmerman
[/TD]
[TD][/TD]
[TD]Gap Inc.[/TD]
[TD]Leonardo Robbins
[/TD]
[/TR]
[TR]
[TD]General Electric[/TD]
[TD]Cayden Myers
[/TD]
[TD][/TD]
[TD]General Electric[/TD]
[TD]Tamara Phillips
[/TD]
[/TR]
[TR]
[TD]Global Gillette[/TD]
[TD]Quinton Dunlap
[/TD]
[TD][/TD]
[TD]Global Gillette[/TD]
[TD]Naima Cisneros
[/TD]
[/TR]
[TR]
[TD]Gucci[/TD]
[TD]Sarah French
[/TD]
[TD][/TD]
[TD]Gucci[/TD]
[TD]Jerimiah Case
[/TD]
[/TR]
[TR]
[TD]Heineken Brewery[/TD]
[TD]Maximo Yu
[/TD]
[TD][/TD]
[TD]Heineken Brewery[/TD]
[TD]Hayden Key
[/TD]
[/TR]
[TR]
[TD]Hermès[/TD]
[TD]Raelynn Mora
[/TD]
[TD][/TD]
[TD]Hermès[/TD]
[TD]Esther Cochran
[/TD]
[/TR]
[TR]
[TD]Hewlett-Packard[/TD]
[TD]Marley Collins
[/TD]
[TD][/TD]
[TD]Hewlett-Packard[/TD]
[TD]Gauge Petersen
[/TD]
[/TR]
[TR]
[TD]Honda Motor Company, Ltd[/TD]
[TD]Drake Knox
[/TD]
[TD][/TD]
[TD]Honda Motor Company, Ltd[/TD]
[TD]Mylee Mathis
[/TD]
[/TR]
[TR]
[TD]HSBC[/TD]
[TD]Roland Alexander
[/TD]
[TD][/TD]
[TD]HSBC[/TD]
[TD]Anna Steele
[/TD]
[/TR]
[TR]
[TD]Jack Daniel's[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Jack Daniel's[/TD]
[TD]Drake Knox
[/TD]
[/TR]
[TR]
[TD]Johnnie Walker[/TD]
[TD]Tamara Phillips
[/TD]
[TD][/TD]
[TD]Johnnie Walker[/TD]
[TD]Roland Alexander
[/TD]
[/TR]
[TR]
[TD]Johnson & Johnson[/TD]
[TD]Naima Cisneros
[/TD]
[TD][/TD]
[TD]Johnson & Johnson[/TD]
[TD]Leonardo Robbins
[/TD]
[/TR]
[TR]
[TD]KFC[/TD]
[TD]Jerimiah Case
[/TD]
[TD][/TD]
[TD]KFC[/TD]
[TD]Tamara Phillips
[/TD]
[/TR]
[TR]
[TD]Kia Motors[/TD]
[TD]Hayden Key
[/TD]
[TD][/TD]
[TD]Kia Motors[/TD]
[TD]Naima Cisneros
[/TD]
[/TR]
[TR]
[TD]Kleenex[/TD]
[TD]Esther Cochran
[/TD]
[TD][/TD]
[TD]Kleenex[/TD]
[TD]Esther Cochran
[/TD]
[/TR]
[TR]
[TD]Kleenex[/TD]
[TD]Paityn Larsen[/TD]
[TD][/TD]
[TD]L'Oréal[/TD]
[TD]Gauge Petersen
[/TD]
[/TR]
[TR]
[TD]L'Oréal[/TD]
[TD]Gauge Petersen
[/TD]
[TD][/TD]
[TD]Mercedes-Benz[/TD]
[TD]Mylee Mathis
[/TD]
[/TR]
[TR]
[TD]Mercedes-Benz[/TD]
[TD]Mylee Mathis
[/TD]
[TD][/TD]
[TD]Mitsubishi[/TD]
[TD]Anna Steele
[/TD]
[/TR]
[TR]
[TD]Mitsubishi[/TD]
[TD]Anna Steele
[/TD]
[TD][/TD]
[TD]Moët et Chandon[/TD]
[TD]Davian Foley
[/TD]
[/TR]
[TR]
[TD]Moët et Chandon[/TD]
[TD]Drake Knox
[/TD]
[TD][/TD]
[TD]MTV[/TD]
[TD]Anna Steele
[/TD]
[/TR]
[TR]
[TD]MTV[/TD]
[TD]Roland Alexander
[/TD]
[TD][/TD]
[TD]Nescafé[/TD]
[TD]Davian Foley
[/TD]
[/TR]
[TR]
[TD]Nescafé[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Nintendo[/TD]
[TD]Leonardo Robbins
[/TD]
[/TR]
[TR]
[TD]Nintendo[/TD]
[TD]Tamara Phillips
[/TD]
[TD][/TD]
[TD]Pampers[/TD]
[TD]Sarah French
[/TD]
[/TR]
[TR]
[TD]Pampers[/TD]
[TD]Naima Cisneros
[/TD]
[TD][/TD]
[TD]Panasonic Corporation[/TD]
[TD]Mathew Simmons
[/TD]
[/TR]
[TR]
[TD]Panasonic Corporation[/TD]
[TD]Esther Cochran
[/TD]
[TD][/TD]
[TD]PepsiCo[/TD]
[TD]Amina Zimmerman
[/TD]
[/TR]
[TR]
[TD]PepsiCo[/TD]
[TD]Gauge Petersen
[/TD]
[TD][/TD]
[TD]Prada[/TD]
[TD]Cayden Myers
[/TD]
[/TR]
[TR]
[TD]Prada[/TD]
[TD]Mylee Mathis
[/TD]
[TD][/TD]
[TD]Samsung Group[/TD]
[TD]Quinton Dunlap
[/TD]
[/TR]
[TR]
[TD]Samsung Group[/TD]
[TD]Anna Steele
[/TD]
[TD][/TD]
[TD]SAP[/TD]
[TD]Sarah French
[/TD]
[/TR]
[TR]
[TD]SAP[/TD]
[TD]Davian Foley
[/TD]
[TD][/TD]
[TD]Siemens AG[/TD]
[TD]Mathew Simmons
[/TD]
[/TR]
[TR]
[TD]Siemens AG[/TD]
[TD]Anna Steele
[/TD]
[TD][/TD]
[TD]The Walt Disney Company[/TD]
[TD]Juliette Lucero
[/TD]
[/TR]
[TR]
[TD]The Walt Disney Company[/TD]
[TD]Davian Foley
[/TD]
[TD][/TD]
[TD]Toyota Motor Corporation[/TD]
[TD]Drake Knox
[/TD]
[/TR]
[TR]
[TD]Toyota Motor Corporation[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Vodafone[/TD]
[TD]Roland Alexander
[/TD]
[/TR]
[TR]
[TD]Toyota Motor Corporation[/TD]
[TD]Leonardo Robbins
[/TD]
[TD][/TD]
[TD]Wells Fargo[/TD]
[TD]Leonardo Robbins
[/TD]
[/TR]
[TR]
[TD]Toyota Motor Corporation[/TD]
[TD]Quinton Dunlap
[/TD]
[TD][/TD]
[TD]Wells Fargo[/TD]
[TD]Tamara Phillips
[/TD]
[/TR]
[TR]
[TD]Vodafone[/TD]
[TD]Sarah French
[/TD]
[TD][/TD]
[TD]Wells Fargo[/TD]
[TD]Naima Cisneros
[/TD]
[/TR]
[TR]
[TD]Wells Fargo[/TD]
[TD]Mathew Simmons
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What I'm trying to do is check if a contact is associated with a certain company. The list on the left has correctly matches up a company with any contacts we have on record. The list on the right is of a contact requesting information on a company. I need to check that the contact in the right list is actually a contact for that company. For example:
Amina Zimmerman is a contact for 3M.
Tamara Phillips has requested information about 3M.
She is not associated with 3M in the left list so she would be denied.
Some of the companies have multiple contacts listed and some contacts are with multiple companies. A vlookup only returns the first instance. Is there anyway to check all contacts for a company?