+ Reply to Thread
Results 1 to 5 of 5

Vlookup with more than one instance of of lookup value

  1. #1
    Registered User
    Join Date
    08-05-2010
    Location
    San FRancisco, California
    MS-Off Ver
    open office for mac
    Posts
    3

    Vlookup with more than one instance of of lookup value

    Someone please help me: Situation is that I'm performing a vlookup function where there is more than one instance of the lookup value. The formula returns the first instance of the value only, I want to sum the results of all instances of this value - any pointers appreciated.
    Last edited by Paul_RRR; 08-05-2010 at 05:43 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Vlookup with more than one instance of of lookup value

    Try SUMIF

    e.g

    =SUMIF(A:A,X1,B:B)

    this will sum values in column B where Column A equals the entry made in X1..

    Adjust as required.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    08-05-2010
    Location
    San FRancisco, California
    MS-Off Ver
    open office for mac
    Posts
    3

    Re: Vlookup with more than one instance of of lookup value

    Thanks, that looks like its going to work but has created a new, though I hope easy to solve problem.

    Quoting your formula above: =SUMIF(A:A,X1,B:B), when I apply this to my sheet the "X1" part is a reference to a cell, in this case A10. If I type A10 the formula wont work, however if I type what cell A10 contains, in this case a batch# RW0716108 the formula works.

    so =SUMIF(Inventory.B5:B113;"=A10";Inventory.J5:J113) does not work
    but =SUMIF(Inventory.B5:B113;"=RW0716108";Inventory.J5:J113) does work

    Any ideas? And thanks for the advice
    Last edited by Paul_RRR; 08-05-2010 at 05:27 PM. Reason: typo

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Vlookup with more than one instance of of lookup value

    Try:

    Please Login or Register  to view this content.

    Regards

  5. #5
    Registered User
    Join Date
    08-05-2010
    Location
    San FRancisco, California
    MS-Off Ver
    open office for mac
    Posts
    3

    Re: Vlookup with more than one instance of of lookup value

    brilliant, cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1