• 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. E

    Look Up with multiple conditions with two sets of date ranges

    Thanks Amritansh but I was nto able to get any results. Thanks Luke this one worked. Thanks Everyone for all your input!
  2. E

    Look Up with multiple conditions with two sets of date ranges

    Luke - Thank You worked like a charm! I do have a small issue which is mainly due to the information on my data table. There are some items that have results that overlap in the timing of it. Is there a way to bring back the highest discount amount rather than summing the values? I know that...
  3. E

    Look Up with multiple conditions with two sets of date ranges

    Jason - For Item 4 your result is correct it would be $2.75. For Item 6 it would return back an error or no results since it would not meet the conditions. Amrit & Luke - Thanks for the input. I need for it to look in the total population in the "Data Table", not an individual line item...
  4. E

    Look Up with multiple conditions with two sets of date ranges

    I have 8000 line file that I am trying to identify a particular discount amount against another file of about 3000 lines. I have to match an item # plus a start and end date with the other file within a date range and bring back a discount/dollar amount. The table will look like this. File...
  5. E

    Hello .. Introduce yourself

    Hello my name is Ed. And I have used this site a few times for some help based on other peoples topics...SO THANK YOU! This is my first forum that I have ever joined. I hope to become as good as all of you at excel.
Back
Top