• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. C

    SUMPRODUCT to lookup based on 2 criteria, ignoring 2nd criteria if not needed

    Works perfectly. Thank you both for you help. Truly appreciate it. Chris
  2. C

    SUMPRODUCT to lookup based on 2 criteria, ignoring 2nd criteria if not needed

    Thank you so much for the help. I have uploaded a test example of the data at: https://dl.dropbox.com/u/84788799/Test.xlsx The blanks are not in the data, but in the lookup dictionary. For clarity, for some codes in code 1, the second code could be anything and does not matter. For others, the...
  3. C

    SUMPRODUCT to lookup based on 2 criteria, ignoring 2nd criteria if not needed

    I have a table of data with two columns (A=code 1) and (B = code 2). I have set up a dictionary that returns a category based on the combination of the codes in column A and B. This data dictionary is held for example as (D = code 1), (E = code 2), (F = category). This works fantastic using...
Back
Top