Results 1 to 17 of 17

Adding Multiple Results Using Vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    Clarendon, Jamaica
    MS-Off Ver
    Excel 2010
    Posts
    8

    Adding Multiple Results Using Vlookup

    I am using Vlookup to search for staff members who have worked overtime, and return the hours worked in a summary sheet. The excel sheet is divided into months and I have created a summary sheet which has the Vlookup formula which is set up to search in the various months for the staff name and record the hours work in the summary sheet. My problem is:

    Sometimes the staff name occurs more than once e.g. Andre Stevens occurs 3x in March. However Vlookup only returns one of the results. How do I get it to add all the results and return the sum in the Summary column?
    Last edited by hawong; 07-09-2012 at 04:59 PM.

Thread Information

Users Browsing this Thread

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

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