+ Reply to Thread
Results 1 to 4 of 4

vlookup between two sheets

  1. 05-20-2014, 11:13 AM #1
    Susht
    Susht is offline
    Registered User
    Join Date
    05-20-2014
    Posts
    2

    vlookup between two sheets

    I am trying to vlookup from sheet2 to sheet1. It gives incorrect values.
    can anyone help me on this
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-20-2014, 11:20 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: vlookup between two sheets

    There is no SINGLE formula in attached file - how can we check?
    My suggestion is:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    and copy right/down
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
  3. 05-20-2014, 11:27 AM #3
    Susht
    Susht is offline
    Registered User
    Join Date
    05-20-2014
    Posts
    2

    Re: vlookup between two sheets

    Sorry. I think i am not clear. Basically i am trying to bring Sum B from sheet 2 to sheet1 and find the difference between sheet2 sumb and sheet1sumb.
    ---What i was tring to do is iam bringing the sumb from sheet2 to sheet1 . But the values doesn't match to the ids nor to the codes. So after bringing them i would like to find the difference. But vlookup doesnot. As it is giving error i didn't put the formula's which i have done on excel.
    Thanks in advance
    Reply With QuoteRegister To Reply
  4. 05-20-2014, 11:39 AM #4
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: vlookup between two sheets

    in J2:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    and copy down
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. vlookup in vba using different sheets
    By RoOmIE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2013, 03:50 PM
  2. VLookup Multiple Sheets - along single row across 52 sheets
    By Poolio19 in forum Excel General
    Replies: 8
    Last Post: 03-30-2011, 11:09 AM
  3. Excel 2007 : Vlookup on 2 different sheets
    By zoukah in forum Excel General
    Replies: 3
    Last Post: 10-07-2009, 04:37 PM
  4. Vlookup across sheets, nested Vlookup possibly?
    By paid2mkgrlspanic in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-09-2009, 05:10 PM
  5. vlookup function-Can vlookup command find the data from the 5 sheets.
    By Rishab shah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1