JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Vlookup with multiple results
Company Contact Company 3M Amina Zimmerman 3M Tamara Phillips Adidas Cayden Myers Adidas Naima Cisneros Adobe Systems Quinton Dunlap Adobe Systems Esther Cochran Apple Inc. Sarah French Apple Inc. Juliette Lucero Avon Mathew Simmons Avon Drake Knox Bank of America Juliette Lucero Bank of America Amina Zimmerman Beko Drake Knox Beko Cayden Myers BMW Roland Alexander BMW Quinton Dunlap Canon Leonardo Robbins Canon Sarah French Cartier SA Tamara Phillips Cartier SA Maximo Yu Chase Naima Cisneros Chase Raelynn Mora Coca-Cola Esther Cochran Coca-Cola Marley Collins Corona Juliette Lucero Corona Drake Knox Facebook, Inc. Drake Knox Facebook, Inc. Roland Alexander Gap Inc. Amina Zimmerman Gap Inc. Leonardo Robbins General Electric Cayden Myers General Electric Tamara Phillips Global Gillette Quinton Dunlap Global Gillette Naima Cisneros Gucci Sarah French Gucci Jerimiah Case Heineken Brewery Maximo Yu Heineken Brewery Hayden Key Hermès Raelynn Mora Hermès Esther Cochran Hewlett-Packard Marley Collins Hewlett-Packard Gauge Petersen Honda Motor Company, Ltd Drake Knox Honda Motor Company, Ltd Mylee Mathis HSBC Roland Alexander HSBC Anna Steele Jack Daniel's Leonardo Robbins Jack Daniel's Drake Knox Johnnie Walker Tamara Phillips Johnnie Walker Roland Alexander Johnson & Johnson Naima Cisneros Johnson & Johnson Leonardo Robbins KFC Jerimiah Case KFC Tamara Phillips Kia Motors Hayden Key Kia Motors Naima Cisneros Kleenex Esther Cochran Kleenex Esther Cochran Kleenex Paityn Larsen L'Oréal Gauge Petersen L'Oréal Gauge Petersen Mercedes-Benz Mylee Mathis Mercedes-Benz Mylee Mathis Mitsubishi Anna Steele Mitsubishi Anna Steele Moët et Chandon Davian Foley Moët et Chandon Drake Knox MTV Anna Steele MTV Roland Alexander Nescafé Davian Foley Nescafé Leonardo Robbins Nintendo Leonardo Robbins Nintendo Tamara Phillips Pampers Sarah French Pampers Naima Cisneros Panasonic Corporation Mathew Simmons Panasonic Corporation Esther Cochran PepsiCo Amina Zimmerman PepsiCo Gauge Petersen Prada Cayden Myers Prada Mylee Mathis Samsung Group Quinton Dunlap Samsung Group Anna Steele SAP Sarah French SAP Davian Foley Siemens AG Mathew Simmons Siemens AG Anna Steele The Walt Disney Company Juliette Lucero The Walt Disney Company Davian Foley Toyota Motor Corporation Drake Knox Toyota Motor Corporation Leonardo Robbins Vodafone Roland Alexander Toyota Motor Corporation Leonardo Robbins Wells Fargo Leonardo Robbins Toyota Motor Corporation Quinton Dunlap Wells Fargo Tamara Phillips Vodafone Sarah French Wells Fargo Naima Cisneros Wells Fargo Mathew Simmons
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
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?
Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Welcome to the forum.
Maybe something like this:
Copy formula down as needed.
Excel Workbook A B C D E F 1 Company Contact Company Request 2 3M Amina Zimmerman 3M Tamara Phillips Denied 3 Adidas Cayden Myers Adidas Naima Cisneros Denied 4 Adobe Systems Quinton Dunlap Adobe Systems Esther Cochran Denied 5 Apple Inc. Sarah French Apple Inc. Juliette Lucero Denied 6 Avon Mathew Simmons Avon Drake Knox Denied 7 Bank of America Juliette Lucero Bank of America Amina Zimmerman Denied 8 Beko Drake Knox Beko Cayden Myers Denied 9 BMW Roland Alexander BMW Quinton Dunlap Denied 10 Canon Leonardo Robbins Canon Sarah French Denied 11 Cartier SA Tamara Phillips Cartier SA Maximo Yu Denied 12 Chase Naima Cisneros Chase Raelynn Mora Denied 13 Coca-Cola Esther Cochran Coca-Cola Marley Collins Denied 14 Corona Juliette Lucero Corona Drake Knox Denied 15 Facebook, Inc. Drake Knox Facebook, Inc. Roland Alexander Denied 16 Gap Inc. Amina Zimmerman Gap Inc. Leonardo Robbins Denied 17 General Electric Cayden Myers General Electric Tamara Phillips Denied 18 Global Gillette Quinton Dunlap Global Gillette Naima Cisneros Denied 19 Gucci Sarah French Gucci Jerimiah Case Denied 20 Heineken Brewery Maximo Yu Heineken Brewery Hayden Key Denied 21 Herms Raelynn Mora Herms Esther Cochran Denied 22 Hewlett-Packard Marley Collins Hewlett-Packard Gauge Petersen Denied 23 Honda Motor Company, Ltd Drake Knox Honda Motor Company, Ltd Mylee Mathis Denied 24 HSBC Roland Alexander HSBC Anna Steele Denied 25 Jack Daniel's Leonardo Robbins Jack Daniel's Drake Knox Denied 26 Johnnie Walker Tamara Phillips Johnnie Walker Roland Alexander Denied 27 Johnson & Johnson Naima Cisneros Johnson & Johnson Leonardo Robbins Denied 28 KFC Jerimiah Case KFC Tamara Phillips Denied 29 Kia Motors Hayden Key Kia Motors Naima Cisneros Denied 30 Kleenex Esther Cochran Kleenex Esther Cochran MATCH 31 Kleenex Paityn Larsen L'Oral Gauge Petersen MATCH 32 L'Oral Gauge Petersen Mercedes-Benz Mylee Mathis MATCH 33 Mercedes-Benz Mylee Mathis Mitsubishi Anna Steele MATCH 34 Mitsubishi Anna Steele Mot et Chandon Davian Foley Denied 35 Mot et Chandon Drake Knox MTV Anna Steele Denied 36 MTV Roland Alexander Nescaf Davian Foley Denied 37 Nescaf Leonardo Robbins Nintendo Leonardo Robbins Denied 38 Nintendo Tamara Phillips Pampers Sarah French Denied 39 Pampers Naima Cisneros Panasonic Corporation Mathew Simmons Denied 40 Panasonic Corporation Esther Cochran PepsiCo Amina Zimmerman Denied 41 PepsiCo Gauge Petersen Prada Cayden Myers Denied 42 Prada Mylee Mathis Samsung Group Quinton Dunlap Denied 43 Samsung Group Anna Steele SAP Sarah French Denied 44 SAP Davian Foley Siemens AG Mathew Simmons Denied 45 Siemens AG Anna Steele The Walt Disney Company Juliette Lucero Denied 46 The Walt Disney Company Davian Foley Toyota Motor Corporation Drake Knox Denied 47 Toyota Motor Corporation Leonardo Robbins Vodafone Roland Alexander Denied 48 Toyota Motor Corporation Leonardo Robbins Wells Fargo Leonardo Robbins Denied 49 Toyota Motor Corporation Quinton Dunlap Wells Fargo Tamara Phillips Denied 50 Vodafone Sarah French Wells Fargo Naima Cisneros Denied 51 Wells Fargo Mathew Simmons
Banned - Rules violations
something like this?
Company Contact R-Company Person 3M Amina Zimmerman Bank of America Amina Zimmerman 3M Amina Zimmerman PepsiCo Amina Zimmerman Gap Inc. Amina Zimmerman Bank of America Amina Zimmerman Gap Inc. Amina Zimmerman PepsiCo Amina Zimmerman Cartier SA Tamara Phillips 3M Tamara Phillips Cartier SA Tamara Phillips General Electric Tamara Phillips Cartier SA Tamara Phillips KFC Tamara Phillips Cartier SA Tamara Phillips Wells Fargo Tamara Phillips Johnnie Walker Tamara Phillips 3M Tamara Phillips Johnnie Walker Tamara Phillips General Electric Tamara Phillips Johnnie Walker Tamara Phillips KFC Tamara Phillips Johnnie Walker Tamara Phillips Wells Fargo Tamara Phillips Nintendo Tamara Phillips 3M Tamara Phillips Nintendo Tamara Phillips General Electric Tamara Phillips Nintendo Tamara Phillips KFC Tamara Phillips Nintendo Tamara Phillips Wells Fargo Tamara Phillips Adidas Cayden Myers Beko Cayden Myers Adidas Cayden Myers Prada Cayden Myers General Electric Cayden Myers Beko Cayden Myers General Electric Cayden Myers Prada Cayden Myers Chase Naima Cisneros Adidas Naima Cisneros Chase Naima Cisneros Global Gillette Naima Cisneros Chase Naima Cisneros Kia Motors Naima Cisneros Chase Naima Cisneros Wells Fargo Naima Cisneros Johnson & Johnson Naima Cisneros Adidas Naima Cisneros Johnson & Johnson Naima Cisneros Global Gillette Naima Cisneros Johnson & Johnson Naima Cisneros Kia Motors Naima Cisneros Johnson & Johnson Naima Cisneros Wells Fargo Naima Cisneros Pampers Naima Cisneros Adidas Naima Cisneros Pampers Naima Cisneros Global Gillette Naima Cisneros Pampers Naima Cisneros Kia Motors Naima Cisneros Pampers Naima Cisneros Wells Fargo Naima Cisneros Adobe Systems Quinton Dunlap BMW Quinton Dunlap Adobe Systems Quinton Dunlap Samsung Group Quinton Dunlap Global Gillette Quinton Dunlap BMW Quinton Dunlap Global Gillette Quinton Dunlap Samsung Group Quinton Dunlap Toyota Motor Corporation Quinton Dunlap BMW Quinton Dunlap Toyota Motor Corporation Quinton Dunlap Samsung Group Quinton Dunlap Coca-Cola Esther Cochran Adobe Systems Esther Cochran Coca-Cola Esther Cochran HermA¨s Esther Cochran Coca-Cola Esther Cochran Kleenex Esther Cochran Kleenex Esther Cochran Adobe Systems Esther Cochran Kleenex Esther Cochran HermA¨s Esther Cochran Kleenex Esther Cochran Kleenex Esther Cochran Panasonic Corporation Esther Cochran Adobe Systems Esther Cochran Panasonic Corporation Esther Cochran HermA¨s Esther Cochran Panasonic Corporation Esther Cochran Kleenex Esther Cochran Apple Inc. Sarah French Canon Sarah French Apple Inc. Sarah French Pampers Sarah French Apple Inc. Sarah French SAP Sarah French Gucci Sarah French Canon Sarah French Gucci Sarah French Pampers Sarah French Gucci Sarah French SAP Sarah French Vodafone Sarah French Canon Sarah French Vodafone Sarah French Pampers Sarah French Vodafone Sarah French SAP Sarah French Bank of America Juliette Lucero Apple Inc. Juliette Lucero Bank of America Juliette Lucero The Walt Disney Company Juliette Lucero Corona Juliette Lucero Apple Inc. Juliette Lucero Corona Juliette Lucero The Walt Disney Company Juliette Lucero Avon Mathew Simmons Panasonic Corporation Mathew Simmons Avon Mathew Simmons Siemens AG Mathew Simmons Wells Fargo Mathew Simmons Panasonic Corporation Mathew Simmons Wells Fargo Mathew Simmons Siemens AG Mathew Simmons Beko Drake Knox Avon Drake Knox Beko Drake Knox Corona Drake Knox Beko Drake Knox Jack Daniel's Drake Knox Beko Drake Knox Toyota Motor Corporation Drake Knox Facebook, Inc. Drake Knox Avon Drake Knox Facebook, Inc. Drake Knox Corona Drake Knox Facebook, Inc. Drake Knox Jack Daniel's Drake Knox Facebook, Inc. Drake Knox Toyota Motor Corporation Drake Knox Honda Motor Company, Ltd Drake Knox Avon Drake Knox Honda Motor Company, Ltd Drake Knox Corona Drake Knox Honda Motor Company, Ltd Drake Knox Jack Daniel's Drake Knox Honda Motor Company, Ltd Drake Knox Toyota Motor Corporation Drake Knox MoA«t et Chandon Drake Knox Avon Drake Knox MoA«t et Chandon Drake Knox Corona Drake Knox MoA«t et Chandon Drake Knox Jack Daniel's Drake Knox MoA«t et Chandon Drake Knox Toyota Motor Corporation Drake Knox BMW Roland Alexander Facebook, Inc. Roland Alexander BMW Roland Alexander Johnnie Walker Roland Alexander BMW Roland Alexander Vodafone Roland Alexander HSBC Roland Alexander Facebook, Inc. Roland Alexander HSBC Roland Alexander Johnnie Walker Roland Alexander HSBC Roland Alexander Vodafone Roland Alexander MTV Roland Alexander Facebook, Inc. Roland Alexander MTV Roland Alexander Johnnie Walker Roland Alexander MTV Roland Alexander Vodafone Roland Alexander Canon Leonardo Robbins Gap Inc. Leonardo Robbins Canon Leonardo Robbins Johnson & Johnson Leonardo Robbins Canon Leonardo Robbins Nintendo Leonardo Robbins Canon Leonardo Robbins Wells Fargo Leonardo Robbins Jack Daniel's Leonardo Robbins Gap Inc. Leonardo Robbins Jack Daniel's Leonardo Robbins Johnson & Johnson Leonardo Robbins Jack Daniel's Leonardo Robbins Nintendo Leonardo Robbins Jack Daniel's Leonardo Robbins Wells Fargo Leonardo Robbins NescafA© Leonardo Robbins Gap Inc. Leonardo Robbins NescafA© Leonardo Robbins Johnson & Johnson Leonardo Robbins NescafA© Leonardo Robbins Nintendo Leonardo Robbins NescafA© Leonardo Robbins Wells Fargo Leonardo Robbins Toyota Motor Corporation Leonardo Robbins Gap Inc. Leonardo Robbins Toyota Motor Corporation Leonardo Robbins Johnson & Johnson Leonardo Robbins Toyota Motor Corporation Leonardo Robbins Nintendo Leonardo Robbins Toyota Motor Corporation Leonardo Robbins Wells Fargo Leonardo Robbins Toyota Motor Corporation Leonardo Robbins Gap Inc. Leonardo Robbins Toyota Motor Corporation Leonardo Robbins Johnson & Johnson Leonardo Robbins Toyota Motor Corporation Leonardo Robbins Nintendo Leonardo Robbins Toyota Motor Corporation Leonardo Robbins Wells Fargo Leonardo Robbins Heineken Brewery Maximo Yu Cartier SA Maximo Yu HermA¨s Raelynn Mora Chase Raelynn Mora Hewlett-Packard Marley Collins Coca-Cola Marley Collins KFC Jerimiah Case Gucci Jerimiah Case Kia Motors Hayden Key Heineken Brewery Hayden Key L'OrA©al Gauge Petersen Hewlett-Packard Gauge Petersen L'OrA©al Gauge Petersen L'OrA©al Gauge Petersen PepsiCo Gauge Petersen Hewlett-Packard Gauge Petersen PepsiCo Gauge Petersen L'OrA©al Gauge Petersen Mercedes-Benz Mylee Mathis Honda Motor Company, Ltd Mylee Mathis Mercedes-Benz Mylee Mathis Mercedes-Benz Mylee Mathis Prada Mylee Mathis Honda Motor Company, Ltd Mylee Mathis Prada Mylee Mathis Mercedes-Benz Mylee Mathis Mitsubishi Anna Steele HSBC Anna Steele Mitsubishi Anna Steele Mitsubishi Anna Steele Mitsubishi Anna Steele MTV Anna Steele Samsung Group Anna Steele HSBC Anna Steele Samsung Group Anna Steele Mitsubishi Anna Steele Samsung Group Anna Steele MTV Anna Steele Siemens AG Anna Steele HSBC Anna Steele Siemens AG Anna Steele Mitsubishi Anna Steele Siemens AG Anna Steele MTV Anna Steele Kleenex Paityn Larsen SAP Davian Foley MoA«t et Chandon Davian Foley SAP Davian Foley NescafA© Davian Foley The Walt Disney Company Davian Foley MoA«t et Chandon Davian Foley The Walt Disney Company Davian Foley NescafA© Davian Foley
or show expected result
Last edited: May 7, 2019
Banned - Rules violations
or even like this
R-Company - Requested Company
Search Company R-Company Tamara Phillips Cartier SA 3M Johnnie Walker General Electric Nintendo KFC Wells Fargo
These are all great! Thank you!
Threads
1,215,654
Messages
6,126,048
Members
449,282
Latest member
Glatortue
