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

    Lookup values with conditions

    Thank you. I've attached a sample. Also, I'm trying to pull the look up values into a pivot table, which I'm not sure will work at all as the pivot table could be grouped or ungrouped and I'm not sure how that would look. So, if that won't work, can you please let me know? Thanks a million...
  2. D

    Lookup values with conditions

    Hello. I'm trying to figure out how to look up a value based on (a)the customer name and (b) the year. There are multiple years for each customer. So, if customer=ABC client and year is 2008, then find that intersection in the data table. But, if year is 2009, 2010 or 2011, I want to add the...
  3. D

    Date range matches

    Thank you, Hui. I also copied this formula over to do the same thing, but with just numbers instead of dates. It returns 1.40 when it should be returning 4.0 except if the value in Col O is "5.__", it returns #VALUE!. My formula is...
  4. D

    Date range matches

    Hi. Need help with a formula that looks up a specific date in a column, finds the range of dates in which it fits and then prints the year assigned to that range in another column. For example, I'm trying to find the year that corresponds to 10/3/11 (in col L) based on the range of dates. The...
Back
Top