+ Reply to Thread
Results 1 to 4 of 4

Finding the value from the list parts and insert extra part in the list

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    319

    Finding the value from the list parts and insert extra part in the list

    I have created 3 list i.e.List no.1 to 3.There are so many parts having in each list.Now,I want to lookup the value of a part ( part indicate in the cell of A4~A58 ), value in the cell F4 ( denotes the parts appearing in the list cell E4) and etc.My expected result are in C4 to C58.Is it possible through VLOOKUP or any other excel formulas?

    Also ,I want insert the extra parts ( appearing in the cell E12~E14 ) in the same list ( E4 ~ E6 ).Is it possible.If yes,then,How?

    [Please refer the attach file for more clarification].

    Regards

    Pradeep Kumar Gupta
    Attached Files Attached Files
    Last edited by PRADEEPB270; 10-15-2010 at 01:39 PM.
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Finding the value from the list parts and insert extra part in the list

    In your VLOOKUP formula change the FALSE to TRUE to enable "fuzzy matching". You will also need to keep your parts list sorted ascending like it is now. Remember that.

    TO be able to add to your list more simply, move it to another sheet. That will look cleaner, too.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2016
    Posts
    319

    Re: Finding the value from the list parts and insert extra part in the list

    I am unable to append the extra part in my list no.1.Can you append all the part highlighted with blue colours in list no.1?I will be grateful to you if this exercise done on my attach file.

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Finding the value from the list parts and insert extra part in the list

    Sorry, the more I look at your sheet the less I'm confident I actually know what you're doing.

    You can add the blue items to the bottom of the list1 and then sort. Not sure what's happening there.

+ 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