+ Reply to Thread
Results 1 to 4 of 4

sum if and vlookup

  1. 06-05-2019, 01:37 PM #1
    mlaxx
    mlaxx is offline
    Registered User
    Join Date
    06-05-2019
    Location
    romania
    MS-Off Ver
    2016
    Posts
    47

    sum if and vlookup

    In cell B3 in Sheet 1, I'd like to add (according to the value in A3) the values that correspond to Sheet 2 for the value in cell A3 but found in column E.
    ex:
    For M4276 (cell value A3) in cell B3, values are collected from Sheet2, values from e28 to e31. So in Sheet1, we should have in B3 the sum of 102.15
    Somewhere I'm tangled at the sumif with vlookup. Any help?
    thx in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-05-2019, 01:50 PM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: sum if and vlookup

    Hi & welcome to the board
    Try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 06-05-2019, 01:53 PM #3
    mlaxx
    mlaxx is offline
    Registered User
    Join Date
    06-05-2019
    Location
    romania
    MS-Off Ver
    2016
    Posts
    47

    Re: sum if and vlookup

    thx Fluff13. is working.
    Reply With QuoteRegister To Reply
  4. 06-05-2019, 01:59 PM #4
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: sum if and vlookup

    You're welcome & thanks for the feedback
    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 - keeping the leading zeros in a cell to allow the vlookup to work
    By UFBEE1970 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-02-2019, 04:41 PM
  2. [SOLVED] Vlookup Error - unable to get the vlookup property of the worksheetfunction class
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2019, 02:59 PM
  3. [SOLVED] Amend VLOOKUP formula to check if a cell is empty and if so perform VLOOKUP
    By robertguy in forum Excel General
    Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  4. Find max value in range then vlookup text in correspond col header & vlookup to table
    By jcskwells in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  5. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  6. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  7. Howto: Vlookup looping (for each...next?). Advise needed about Vlookup loop technique
    By Wino in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 07:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1