+ Reply to Thread
Results 1 to 3 of 3

How to look up and compare data on different worksheets then display result when matched

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    Southampton England
    MS-Off Ver
    Mac 14.00
    Posts
    3

    How to look up and compare data on different worksheets then display result when matched

    Hi all can anyone please help?

    I have worksheet 1 with data that does not change…

    Worksheet 1
    A B
    1 Fish 7
    2 Sugar 4
    3 Eggs 11

    and worksheet 2 with a list of mixed data …

    Worksheet 2
    A B C D etc……… K
    1 Fish ? : :
    2 Sugar ? : :
    3 Eggs ? : :
    4 Sugar ? : :
    5 Sugar ? : :
    6 Sugar ? : :
    7 Eggs ? : :
    8 Sugar ? : :
    9 Fish ? : :
    10 Fish ? : :

    I wish to use a function or formula that can be place in Worksheet 2 column K that will look at the list in Worksheet 2 A1:A10 and compare the items to Worksheet 1 A1:A3
    When a match is found then the result will be the value that corresponds to the item in Worksheet 1
    and appear in column K

    Result

    Worksheet 2
    A B C D etc……… K
    1 Fish ? : : 7
    2 Sugar ? : : 4
    3 Eggs ? : : 11
    4 Sugar ? : : 4
    5 Sugar ? : : 4
    6 Sugar ? : : 4
    7 Eggs ? : : 11
    8 Sugar ? : : 4
    9 Fish ? : : 7
    10 Fish ? : : 7

    Please can anyone help this newbie?

    Kind Regards

    Gary

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: How to look up and compare data on different worksheets then display result when match

    A VLOOKUP should do the trick, =VLOOKUP(b2,worksheet1!b:c,2, false)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: How to look up and compare data on different worksheets then display result when match

    Btw, you didn't have to start a new post, just using the thread tools at the top you can change the title, it is hard to type all of that using an iPad.

+ 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. Replies: 1
    Last Post: 01-07-2014, 09:09 PM
  2. Replies: 11
    Last Post: 07-23-2013, 04:07 PM
  3. Replies: 19
    Last Post: 05-15-2013, 02:54 PM
  4. Compare the repeated value and display the result
    By gurum in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 07:56 AM
  5. How to compare data between 2 worksheets and display the differences
    By melvyndb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2012, 02:48 AM
  6. code to compare two worksheets and getting corresponding values of matched entities
    By mechsanket in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-26-2011, 03:00 PM
  7. Display matched table data in another sheet
    By vanir in forum Excel General
    Replies: 2
    Last Post: 08-30-2009, 09:02 PM
  8. Compare data and copy to matched row
    By mark_jam3s in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2008, 06:58 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