Results 1 to 7 of 7

How to combine Vlookup and Sumproduct

Threaded View

  1. 01-21-2014, 04:52 AM #1
    Shihab
    Shihab is offline
    Registered User
    Join Date
    02-04-2012
    Location
    Muscat
    MS-Off Ver
    Excel 2010
    Posts
    20

    How to combine Vlookup and Sumproduct

    Hi Dear,

    I have a file with two work sheet, in 1 sheet have monthly allowance to staff in 2nd sheet I need the data in a schedule format. Please see the attached file, my formula not working here properly. Kindly suggest me a appropriate formula to solve the issue.

    Thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. How to combine SUMPRODUCT & SUMIF
    By laferg69 in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 10-12-2013, 06:05 PM
  2. [SOLVED] combine SUMIF and SUMPRODUCT
    By brownn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-25-2012, 11:16 PM
  3. Need to combine SUMIF & SUMPRODUCT
    By laferg69 in forum Excel General
    Replies: 1
    Last Post: 07-26-2011, 04:21 AM
  4. combine sumif and sumproduct
    By nicko54 in forum Excel General
    Replies: 1
    Last Post: 09-02-2008, 11:41 AM
  5. [SOLVED] SUMPRODUCT - How to combine
    By Robert in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-01-2005, 10:06 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