+ Reply to Thread
Results 1 to 3 of 3

Vlookup and partial data match problem

  1. #1
    Registered User
    Join Date
    11-04-2010
    Location
    New York, USA
    MS-Off Ver
    Excel 2003
    Posts
    34

    Vlookup and partial data match problem

    I have the following in worksheet 1

    Cell B2
    30543

    Whereas in worksheet 2, I have the following

    Cell A2
    S51410

    Cell B2
    11-DEOXYCORTISOL, LC/MS/MS, SERUM [30543X]

    I'd like to do the following:
    Condition: Exclude any 'X' at the end of cell B2 from the 2nd sheet and if the value (i.e.30543) is similar to Cell B2 from the 1st Sheet.

    then result: Display value of Cell A2 from the 2nd worksheet (S51410) in Cell E2 of the 1st Sheet

    I am about to bang my head on the wall with this. Any help is highly appreciated. Thanks
    Last edited by pandyav; 12-14-2011 at 10:12 AM.

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Excel help please

    It is possible with LOOKUP.

    Please take a few minutes to read forum rules and change your title accordingly.

    Forum Rule
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Vlookup and partial data match problem

    Try this;

    =LOOKUP(9E300,SEARCH(B2,Sheet2!B$2:B$50),Sheet2!A$2:A$50)

    Adjust the ranges.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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