+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 16 of 16

Multiple area LOOKUP + SUM value

  1. #16
    Forum Expert XLent's Avatar
    Join Date
    MS-Off Ver

    Re: Multiple area LOOKUP + SUM value

    @kimgag, suffice to say my prior suggestion didn't sit comfortably with me (given performance)

    I've attached an alternative version which should be quicker as, in hindsight, the introduction of the DNR referenced in my prior post / attachment is only going to slow things down.

    Per the prior example I would still advise sorting the 'Demand per material tab' data (by Col A) but you needn't sort the Labor tab.

    As before, to reduce file size, I have removed the formulae from rows 3 onwards in both Final & Labor tabs, to reinstate copy calcs in row 2 downwards.

    With all formulae in place the file should calculate in a second or so.

    edit: I also note, belatedly, that my previous suggestion included some rogue values {more specifically August & September}, apologies for any confusion caused.
    Attached Files Attached Files
    Last edited by XLent; 11-10-2018 at 04:01 AM.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

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


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