+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP multiple return and SUM issues

  1. #1
    Registered User
    Join Date
    01-19-2021
    Location
    Scotland
    MS-Off Ver
    Office 2010
    Posts
    1

    VLOOKUP multiple return and SUM issues

    Hi all, hoping someone has a solution for me.

    I have a large sheet which contains monthly delivery numbers for each store in my network. The columns contain other data but for a new sheet I'm creating, all I need is a table showing total customer deliveries for each store on a given day. The table I created is fairly simple, each store (has a unique job ID) is at the top of the column and every date in the month is at the start of the row. My problem has been in the way that our monthly reports are now sent to us, if one or more drivers visit the same store in the same day then this creates another line of data, with the same job ID and date. Vlookup will only return the first answer it finds, whereas I need the total of all the potential answers to the Vlookup. Is there a fairly straightforward way to do this? I've heard SUMIF may be of use in this scenario?

    Also, as the data I'm working from has the whole month, when I've been looking for the daily totals I've only been highlighting the data in the table array that pertains to that day as opposed to the whole sheet. Is there a quicker way to do this?

    Thanks for any help in advance.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,772

    Re: VLOOKUP multiple return and SUM issues

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 05-27-2019, 03:46 PM
  2. Issues referencing multiple workbooks with vlookup
    By dr.doom76 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2018, 09:28 AM
  3. Vlookup to return multiple rows in return
    By Excelhelpss in forum Excel General
    Replies: 1
    Last Post: 06-18-2015, 09:59 AM
  4. Replies: 2
    Last Post: 05-14-2015, 12:31 PM
  5. Help using vlookup to return multiple results for one vlookup value
    By Akmon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2015, 06:00 AM
  6. [SOLVED] Issues with VLOOKUP/INDIRECT and retrieving from multiple sheets
    By nicolerork in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-28-2013, 12:53 AM
  7. Vlookup multiple sheet issues
    By WeedMan in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 08-16-2011, 07:08 PM

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