Results 1 to 20 of 20

Multiple Lookup within same cell

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2017
    Location
    Milan
    MS-Off Ver
    Office 2013
    Posts
    47

    Multiple Lookup within same cell

    Hi,
    i'm trying to validate each comma separated value of a string to return the errors(values not found)
    in the file attached in tab Import_data,column T i would like to verify if every size exists in the Mastergrids file.
    i managed to write the formula but it is only for the first size in the cell. Also, my idea was to leave it blank in case of Match,and only populate the cell in case of Mismatch.

    is there anyone who has any idea on how to do it?

    Thanks everyone for the support
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Multiple lookup in one cell?
    By goodquestionmma in forum Excel General
    Replies: 4
    Last Post: 01-13-2020, 12:00 PM
  2. multiple cell lookup
    By bradyman699 in forum Excel General
    Replies: 7
    Last Post: 11-25-2016, 10:11 AM
  3. Replies: 5
    Last Post: 10-07-2016, 01:19 AM
  4. Replies: 3
    Last Post: 08-16-2016, 07:58 AM
  5. Multiple character lookup in cell
    By CAABYYC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-10-2016, 04:13 PM
  6. Replies: 9
    Last Post: 08-20-2014, 04:43 PM
  7. Multiple cell lookup
    By Cousby in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2011, 10:43 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