+ Reply to Thread
Results 1 to 3 of 3

Comparing two lists

  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    London
    MS-Off Ver
    excel 2010
    Posts
    6

    Comparing two lists

    I have come across a situation where i have to compare the inventory and update it with up to date prices.
    For Example i have these two lists
    Current List
    Item No. Price

    Item 1 12
    Item 2 19
    Item 3 17
    Item 4 14


    Updated List
    Item No. Price

    Item 3 21
    Item 1 15
    Item 4 19


    Required Results: I want to sort the updated list and place it in front of Current List. And remember there are thousands of entries so for the missing items in Updated List i just want to delete them. This is what i am looking for.
    Current List Updated Price
    Item No. Price Item No. Price

    Item 1 12 Item 1 15
    Item 2 19 ------ ---
    Item 3 17 Item 3 21
    Item 4 14 Item 4 19

    If there is any solution that does not involve VB or Macro that will be very easy for me.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Comparing two lists

    Use in Col C and Col D (against Current list) respectively

    =IFERROR(VLOOKUP($A1,$A$6:$B$8,1,FALSE),"") and
    =IFERROR(VLOOKUP($A1,$A$6:$B$8,2,FALSE),"")
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Comparing two lists

    Thanks for the rep!

    If you are happy with the solution provided, please mark the thread as solved

    To mark your thread solved do the following:
    - Go to the first post
    - Click edit
    - Click Advance
    - Just below the word "Title:" you will see a dropdown with the word No prefix.
    - Change to Solve
    - Click Save

    Enjoy the forum!

+ 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