+ Reply to Thread
Results 1 to 6 of 6

Lookup Multiple Values In A Single Cell (sepa By Commas) and return lowest number in range

  1. #1
    Registered User
    Join Date
    07-07-2013
    Location
    SF, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Lookup Multiple Values In A Single Cell (sepa By Commas) and return lowest number in range

    I would like to find a formula (in Target Tab Col B) that will help lookup the lowest % based on the values in the Data Tab. The lookup cell could contain more than 1 value.
    For example:

    Data Tab
    Col A Col B
    A 50%
    B 40%
    C 10%
    D 90%


    Target Tab
    Col A (set) Col B (Value)
    A 50%
    A, B 40% ( since A is 50%, B is 40%, it returns the value of 40%)
    A, B, C 10%
    A, D 50%

    Thank you.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,298

    Re: Lookup Multiple Values In A Single Cell (sepa By Commas) and return lowest number in r

    Hi and welcome to the forum

    I think you are going to have to give a bit more detail on what you are working with, and what your expected outcome would be. Please upload a sample workbook showing this?
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-07-2013
    Location
    SF, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Lookup Multiple Values In A Single Cell (sepa By Commas) and return lowest number in r

    Thank you. I've attached a simple file with my expected outcome. Thanks in advance
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: Lookup Multiple Values In A Single Cell (sepa By Commas) and return lowest number in r

    Target, B2, control+shift+enter, not just enter, and copy down:

    =MIN(IF(ISNUMBER(SEARCH(data!$A$2:$A$5,A2)),data!$B$2:$B$5))

  5. #5
    Registered User
    Join Date
    07-07-2013
    Location
    SF, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Thumbs up [SOLVED]Re: Lookup Multiple Values In A Single Cell (sepa By Commas) and return lowest

    Thank you Aladin. It works

  6. #6
    Forum Contributor
    Join Date
    12-23-2003
    Posts
    179

    Re: [SOLVED]Re: Lookup Multiple Values In A Single Cell (sepa By Commas) and return lowest

    You are welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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