+ Reply to Thread
Results 1 to 3 of 3

Vlookup ? Comparison of 2 worksheets data then value is entered into 2nd worksheet

  1. #1
    Registered User
    Join Date
    09-27-2014
    Location
    Manchester, England
    MS-Off Ver
    MS Office 2010
    Posts
    4

    Question Vlookup ? Comparison of 2 worksheets data then value is entered into 2nd worksheet

    Please can someone help....


    My first worksheet has


    a1 0.5 b2
    d2 0.6 c3
    e4 1.3 f4
    h6 0.5 s6



    My second worksheet would be automatically populated

    a1 no. from above b2
    d5 "Not Found" c3
    e4 "Not Found" g4
    h6 no. from above s6


    I want a syntax or similar that will automatically populate the second worksheet, only when the corresponding values are the same i.e. a1 b2
    and if not ie d5 c3 and e4 f4, it states "Not Found"
    Last edited by dataquest; 09-27-2014 at 02:12 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    Re: Vlookup ? Comparison of 2 worksheets data then value is entered into 2nd worksheet

    Hi Dataquest,

    I've responded to your query in this thread. http://www.excelforum.com/excel-form...ml#post3848221

  3. #3
    Registered User
    Join Date
    09-27-2014
    Location
    Manchester, England
    MS-Off Ver
    MS Office 2010
    Posts
    4

    Re: Vlookup ? Comparison of 2 worksheets data then value is entered into 2nd worksheet

    Cheers Snook

    Much Appreciated !

+ 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. Macro-need help sorting data to other worksheets/update as new data is entered.
    By Beefy1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2014, 12:09 PM
  2. Copy and paste the most recent entered data from other worksheets to summary sheet
    By cvsrini in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2013, 04:51 AM
  3. [SOLVED] Data comparison between worksheets of very different sizes
    By mellowmarshall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2013, 08:54 PM
  4. Data/shapes entered in worksheet, how do duplicate data to another worksheet?
    By barleycorn in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-22-2012, 04:57 PM
  5. Data Comparison between worksheets - Macro
    By masterp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2007, 10:26 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