+ Reply to Thread
Results 1 to 2 of 2

Match a Value from a single-cell, comma separated list

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    5

    Match a Value from a single-cell, comma separated list

    Good Day to all,

    I am working on a project for a foods partner which requires me to list ingredients with possible allergens in them. I have made a list of the possible allergens, and what category they belong in. What I need is a macro or formula that will match any allergen ingredients in a particular item

    On one tab entitle DLR Items List, I have a list of allergen ingredients.

    On another tab entitled DLR Product Ingredient Viewer, I have the automated Ingredient sheet. I need a macro or formula that evaluates the ingredients on this page, and matches them to the allergen list on the other page (Photo 2 Attached)

  2. #2
    Registered User
    Join Date
    06-27-2014
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    5

    Re: Match a Value from a single-cell, comma separated list

    here is a link to the workbook https://app.box.com/s/ut4fwggg4oit8xh63ut2

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare comma separated values in a cell to a list
    By SMB in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-03-2019, 01:10 AM
  2. Macro to create a list of sheets, separated with comma in a single cell
    By manolomana in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2014, 11:00 AM
  3. Replies: 3
    Last Post: 12-23-2013, 12:32 PM
  4. [SOLVED] Single cell Comma Separated Values to validation list [DIFFICULT QUESTION]
    By jgema in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-31-2013, 08:48 PM
  5. Column/cells to single cell comma separated data?
    By egeorge4 in forum Excel General
    Replies: 1
    Last Post: 04-27-2007, 03:53 PM

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