Results 1 to 5 of 5

CLOSEST MATCH/VLOOKUP Multiple Cells? PIZZA EXAMPLE

Threaded View

imsteve123 CLOSEST MATCH/VLOOKUP... 11-19-2019, 03:12 PM
Glenn Kennedy Re: CLOSEST MATCH/VLOOKUP... 11-20-2019, 04:12 AM
Pepe Le Mokko Re: CLOSEST MATCH/VLOOKUP... 11-20-2019, 04:13 AM
imsteve123 Re: CLOSEST MATCH/VLOOKUP... 11-20-2019, 03:16 PM
JeteMc Re: CLOSEST MATCH/VLOOKUP... 11-23-2019, 10:04 AM
  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    NJ
    MS-Off Ver
    Excel 2013
    Posts
    9

    CLOSEST MATCH/VLOOKUP Multiple Cells? PIZZA EXAMPLE

    Hi lovely people of ExcelForum,

    Let's say I have a reference table (we'll use food right now cause I'm hungry) of pizza companies,thick/thin crust,toppings. The outcome of the combination is good/bad.

    Company Crust Toppings Outcome
    Pizza Hut Thick Pepperoni Good
    Pizza Hut Thin Bad
    Dominoes Green Peppers Good
    Papa John's Thick Pineapple Bad

    As there are thousands of possible combinations outside of this reference sheet, is there a way to MATCH or VLOOKUP a list of these combinations to only this reference table? If there isn't an exact match, the outcome would be taken from the closest match. For ex if I have Pizza Hut, Thin Crust, Olives -- the closest reference would be Pizza Hut & Thin Crust which would pull the outcome BAD.

    Let me know if this makes sense and any help would be greatly appreciated.

    Thank you in advance!
    Last edited by imsteve123; 11-19-2019 at 03:17 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Closest match for VLOOKUP?
    By zarize92 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-08-2018, 09:58 AM
  2. VLookup not to closest match
    By RandWald in forum Excel General
    Replies: 5
    Last Post: 12-26-2015, 07:17 AM
  3. [SOLVED] Vlookup with 3 criteria and closest match
    By martinpgibson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-09-2015, 11:06 PM
  4. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  5. Vlookup with closest match and exact match
    By hooshies in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-01-2013, 01:13 PM
  6. vlookup or indexmatch on closest name match?
    By jw01 in forum Excel General
    Replies: 4
    Last Post: 05-14-2012, 03:38 PM
  7. Vlookup Closest Match
    By adam2308 in forum Excel General
    Replies: 4
    Last Post: 06-17-2009, 10:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1