Results 1 to 5 of 5

Lookup multiple items

Threaded View

YasserKhalil Lookup multiple items 07-15-2016, 04:14 AM
millz Re: Lookup multiple items 07-15-2016, 04:55 AM
YasserKhalil Re: Lookup multiple items 07-15-2016, 05:08 AM
jindon Re: Lookup multiple items 07-15-2016, 05:24 AM
YasserKhalil Re: Lookup multiple items 07-15-2016, 08:27 AM
  1. 07-15-2016, 04:14 AM #1
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Lookup multiple items

    Hello forum experts
    I have data in column A & B (Code and description)
    For example : Apple has the code 15

    In column C I have multiple items in one cell and need to extract the code for all these items and get the results concatented
    For example : for the following items (Mango,Apple,Banana) I need to extract the codes in column D to be like that (18,15,17)

    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup multiple items
    By shauncasey in forum Excel General
    Replies: 8
    Last Post: 02-12-2015, 03:04 PM
  2. List Top Ten Items - Multiple Criteria Lookup With Multiple Results - Sorted Descending
    By Whizbang in forum Excel General
    Replies: 1
    Last Post: 09-04-2014, 12:14 PM
  3. [SOLVED] Lookup multiple items
    By kingkong321 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2014, 12:55 PM
  4. Multiple Lookup Items
    By choke in forum Excel General
    Replies: 1
    Last Post: 06-18-2012, 01:29 PM
  5. Lookup with multiple items
    By hard at work declan in forum Excel General
    Replies: 3
    Last Post: 11-19-2008, 10:05 AM
  6. How to add multiple items using lookup?
    By Weasel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2008, 06:34 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1