+ Reply to Thread
Results 1 to 2 of 2

Lookup and sum

  1. 01-11-2018, 06:46 AM #1
    Roma1r
    Roma1r is offline
    Registered User
    Join Date
    01-02-2014
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    88

    Lookup and sum

    Need results in column G sheetb - Need to lookup column A in Sheetb from sheeta column E and sum numbers in column G sheeta
    hope it makes sense - see attachment
    thanking you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-11-2018, 06:54 AM #2
    PaulM100
    PaulM100 is offline
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Lookup and sum

    This will work:
    In G3, drop-down:

    Please Login or Register  to view this content.
    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. Lookup formula that matches name and selects the closest date that is greater than lookup
    By mntroth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-23-2017, 07:04 PM
  2. Two Lookup and Return (Lookup the column, then lookup the row)
    By Branbran10 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2015, 04:55 PM
  3. Index lookup with 2 lookup values and then return multiple results - array formula
    By D.Lovell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  4. [SOLVED] Multiple Lookup Values rows and columns to lookup a single target column on the right end.
    By gurusanthanam in forum Excel General
    Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  5. LOOKUP - I need to lookup a value where the lookup vector is in any order
    By LukeMC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2013, 08:46 AM
  6. Search lookup array to find lookup value contained within text string
    By Cookstein2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2011, 09:42 AM
  7. VBA: Index/Match. 1 lookup value, 1 lookup array. copies cells from multple columns.
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2011, 12:51 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