+ Reply to Thread
Results 1 to 7 of 7

Retrieving information fron two sheets

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Retrieving information fron two sheets

    Hi Excel Genius,

    I have a question. Here is what i am trying to do.

    Sheet 1
    A1 B1
    Name Approval Date
    Jason 12/15/2013
    Bob 09/06/2013

    Sheet 2

    A1 B1 C1
    Name Completed Date Comment
    Jason 11/15/2013 Completed Date cannot be before after approval date
    Bob 10/06/2013 Fine

    Can anyone help with the formula? Basically, in sheet 1, all the names and when it was approved is there. In Sheet 2, it will look at sheet 1 approval date and corresponding name. If the completed date is after the approval date, it is fine. If it is before the approval date, it should give some kind of error message.

    Can anyone help?

    Thank you

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Retrieving information fron two sheets

    Hi
    Cut and paste this formula into Cell C2 on Sheet 2 and copy down accordingly.

    =IF(B2>(VLOOKUP(A2,Sheet1!A:B,2,FALSE)),"Fine","Completed date cannot be before the approval date")

    Hope this helps.
    Good luck.
    Tony

  3. #3
    Registered User
    Join Date
    10-25-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Retrieving information fron two sheets

    Yes, it works beautifully. Thank you so much!!!!!

  4. #4
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Retrieving information fron two sheets

    Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

    In future, to mark your thread as Solved, you can do the following -
    Select Thread Tools-> Mark thread as Solved.

    Incase your issue is not solved, you can undo it as follows -
    Select Thread Tools-> Mark thread as Unsolved.

    Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  5. #5
    Registered User
    Join Date
    10-25-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Retrieving information fron two sheets

    Hi,

    I thought i had it all figured out, but it doesn't seem to work. I have included the spreadsheet with more details.

    There are two tabs in the spreadsheet. Once is the TrainingItems tab and the other one is the Training History. If you look at the column in J2, you will see that there's a formula. All i need is to look at the trainingitemcode and the completion date in Training History. If you go to TrainingItems, it cannot be less equal than the approval date that corresponds to the CW TrainingItemCode.

    TrainingItems Tab

    CW TrainingItemCode: JCO-EMEA-SOP MQP 3.4.0.02 v1.00 Knowledge
    Approval Date: 03/18/2012


    Training History
    CW TrainingItemCode: JCO-EMEA-SOP MQP 3.4.0.02 v1.00 Knowledge
    Completion Date: 02/18/2012
    If it is before the approval date, it gives an error message
    If it is equal or after the approval date, it is fine.

    Thank you guys!
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: Retrieving information fron two sheets

    Hi
    This is because in the sample the column being compared was column 2, in your spreadsheet the column being compared is column 7. Use this formula:

    =IF(B2>(VLOOKUP(A2,Sheet1!A:B,7,FALSE)),"Fine","Completed date cannot be before the approval date")

    Good luck.
    Tony

  7. #7
    Registered User
    Join Date
    10-25-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Retrieving information fron two sheets

    Thank you ARGK. It works!!!!!

+ 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. Retrieving information from other sheets
    By drzero328 in forum Excel General
    Replies: 6
    Last Post: 07-18-2012, 11:13 PM
  2. Retrieving information from a webform
    By spartan81 in forum Excel General
    Replies: 1
    Last Post: 02-09-2011, 05:18 AM
  3. Retrieving information
    By facuse in forum Excel General
    Replies: 8
    Last Post: 12-03-2009, 01:30 PM
  4. retrieving information
    By hsb101 in forum Excel General
    Replies: 1
    Last Post: 08-03-2006, 04:15 AM
  5. Retrieving information for a day of the week...
    By Chase in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-21-2005, 12:05 PM

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06566 seconds
  • Memory Usage 9,022KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (4)showthread_bookmarksite
  • (5)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1