+ Reply to Thread
Results 1 to 7 of 7

Vlookup in Duplicate Result Value

  1. #1
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010
    Posts
    256

    Vlookup in Duplicate Result Value

    Plzzzz Help,

    I have the following data in sheet1.

    P.Code Material Description ShortDescription
    31011000 12.00-20 TUBE 12.00-20
    31011500 12.00-20 INS TUBE 12.00-20
    31021000 11.00-20 TUBE 11.00-20
    31021500 11.00-20 INS TUBE 11.00-20
    31021510 11.00-20 MT INS TUBE 11.00-20
    31031000 10.00-20 INS TUBE 10.00-20
    31031100 10.00-20 MT TUBE 10.00-20
    31031300 10.00-20 PLUS TUBE 10.00-20
    31031400 10.00-20 TRADE TUBE 10.00-20
    31031500 10.00-20 OE TUBE 10.00-20
    31031510 10.00-20 MT INS TUBE 10.00-20
    31031520 10.00-20 TR INS TUBE 10.00-20
    31031600 10.00-20 FT INS TUBE 10.00-20
    31031610 10.00-20 FT TUBE 10.00-20


    and the data in sheet2 is:
    A B C
    1 Material Description ShortDescription Stk
    2 11.00-20 MT INS TUBE 1
    3 10.00-20 MT INS TUBE 271
    4 10.00-20 TR INS TUBE 1
    5 10.00-20 FT INS TUBE 9
    6 10.00-20 FT TUBE 1

    I need a formula in cell B2 of sheet2 to lookup the value of A2 from sheet1 in "ShortDescription" column.

    Vlookup is not working here because of multiple results value. kindly help....!!!

    PS : I have also attached my file.
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Vlookup in Duplicate Result Value

    I dont understand why the regular V Look Up wont work??

    I tried this is B2 and it worked.

    =VLOOKUP(A2,Sheet1!$B$2:$C$415,2,0)
    Cheers!
    Deep Dave

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Vlookup in Duplicate Result Value

    Oopsss... Sorry!!


    Try this in cell b2

    =INDEX(Sheet1!$A$2:$A$415,MATCH(A2,Sheet1!$B$2:$B$415,0))


    Deep

  4. #4
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Vlookup in Duplicate Result Value

    Please confirm if im right.
    Attached Files Attached Files
    Please click 'Add reputation', if my answer helped you.

  5. #5
    Forum Contributor
    Join Date
    07-09-2013
    Location
    Nagpur, India
    MS-Off Ver
    Excel 2010
    Posts
    256

    Re: Vlookup in Duplicate Result Value

    yup...!! SOLVED... I got it....!!!

    Thankss a lot Mr. Ramanan and msexcelathome....
    Last edited by abhinavbinkar; 07-25-2013 at 05:04 AM.

  6. #6
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Vlookup in Duplicate Result Value

    You are Most welcome Abhinav.

  7. #7
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Vlookup in Duplicate Result Value

    Glad it helped!!

+ 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. how to bring all vlookup returns even with duplicate vlookup search keys
    By NYC4LIFE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2013, 04:53 PM
  2. isblank & vlookup formula returns #n/a result and incorrect result
    By helpmeplease333 in forum Excel General
    Replies: 5
    Last Post: 05-06-2012, 11:41 PM
  3. Duplicate Post > Cell shows formula instead of result
    By sandeephg in forum Excel General
    Replies: 1
    Last Post: 09-27-2007, 01:33 AM
  4. VLookup Sum Result Help.
    By bijusidharth in forum Excel General
    Replies: 2
    Last Post: 04-20-2007, 05:35 AM
  5. [SOLVED] vlookup based on random result returns incorrect result
    By rickat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2005, 09:20 AM

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