+ Reply to Thread
Results 1 to 2 of 2

vlookup in different sheet within formula to return sum of column based on result of vlook

  1. 11-16-2015, 03:08 PM #1
    mecexcel
    mecexcel is offline
    Registered User
    Join Date
    10-23-2015
    Location
    united states
    MS-Off Ver
    2013
    Posts
    23

    vlookup in different sheet within formula to return sum of column based on result of vlook

    Hello,
    I have attached an excel with what I need help with. In the first tab "formula" is the formula that I need help editing.
    I need to look within the ta decide-summary tab and do a vlookup for column A- OPEID. I need to see which of these match the OPEID in the tab Lookup A- If they dont match, I dont want anything to happen (or just return 0 or blank), if they do match, I need to sum column I only for the matching vlookups. Is this possible and can you help me edit the formula that I have to accommodate this so that I don't need to have the extra columns at the end of TA Decide- Summary?

    Thank you for anyone that can helpexcelhelp1.xls
    Reply With QuoteRegister To Reply
  2. 11-16-2015, 03:36 PM #2
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: vlookup in different sheet within formula to return sum of column based on result of v

    I added a test column in TA Decide (which can be hidden)
    in A2 copied down
    =ISNUMBER(MATCH(TEXT(B2,"00000000"), 'Lookup AA'!$A$2:$A$155,0))

    Then

    =SUMIF('TA Decide - Summary'!$A:$A, TRUE, 'TA Decide - Summary'!$I:$I)
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    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. How to return a blank result when using SUM(VLOOKUP formula??
    By Shannon561 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-13-2014, 03:49 AM
  2. Need help with a date comparison formula - Return text based on result
    By kcleere in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2013, 03:58 PM
  3. VBA to compare data from two sheets and return value from column based on result.
    By twanbiz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2013, 11:33 AM
  4. Return result based of column name
    By MathiasH in forum Excel General
    Replies: 1
    Last Post: 10-09-2011, 02:43 AM
  5. Multiple sumif & vlookup formula to combine info and return result in seperate sheet
    By wilhelm_iv in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2010, 08:36 PM
  6. Formula to return maximum amount between fixed value and vlookup result
    By simon4sam in forum Excel General
    Replies: 3
    Last Post: 08-13-2008, 08:25 AM
  7. [SOLVED] Return a text string when the result of VLOOKUP formula is #N/A
    By jeremy nickels in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-04-2006, 12:30 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