+ Reply to Thread
Results 1 to 1 of 1

Multiple Columns Lookup within same cell

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

    Multiple Columns Lookup within same cell

    Hi, i am posting this request since i am not able to find a solution to what I am looking for. I attached the sample file to be used as reference.
    i have 3 tabs:
    "Data" contains a list of Style codes in column C and from column E to P(it may vary and become longer) i have as a header a feature name and in the cells below, identified with TRUE/FALSE, we can see if that feature is available for the style code
    "Config list": here we have the current list of features(could be longer). the feature name is in column A and in Column B there is the Feature code.
    "Import_Data":inside this tab i have the style code in column A, please not that here the style code is 3 digits longer than the one in sheet "Data". in Column AS i have the field Technologies. the result expected is to lookup the first 6 digits of the material codes in column A, find them in sheet "Data" and return the codes of the features marked with TRUE(split by a comma if multiple values are found) or left blank if no TRUE value is found. in column AS i have put the expected result. the number of material codes in column A can vary.
    Attached Files Attached Files

+ 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] Lookup multiple criteria in multiple columns in multiple rows; return true if exists
    By ufdlim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-07-2019, 02:03 PM
  2. Replies: 8
    Last Post: 09-21-2017, 03:43 PM
  3. Lookup Cell Value and return multiple columns with HTML tags added
    By whiterosetools in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-19-2016, 02:35 PM
  4. Replies: 5
    Last Post: 02-13-2015, 11:04 AM
  5. Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  6. [SOLVED] Multiple lookup adding columns, then multiplying, then lookup, add, and subtract
    By mamig in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2013, 12:55 AM
  7. Lookup adjacent column to multiple lookup columns.
    By JAMES4228 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2009, 03:19 PM

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