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

    Index + Match + List name

    Hi Bosco Thank you, your proposals are exactly what I looking for. Your solution for the test 2 is obvious, I blame myself for not thinking about use "Substistute" function. However the test 3 and 4, I didn't know INDIRECT, I will learn how this function works, it seems very useful.
  2. N

    Index + Match + List name

    Hello, I need some advices regarding my formula Index - Match which use a name range. When I use my formula with the name like this, I return correctly the value. =INDEX(Volume_total;MATCH(A8&B8;Date&Customer;0)) I guess it’s because I write the name range directly in my formula. But I use a...
  3. N

    My formula with 4 conditions doesn't return correct value

    Thank you bosco_yip and Luke M for yours ninja replies @bosco_yip your formula meets my needs, I have understood my error. @Luke M I understand your approach to simplify the formula I will try to reapply it in my file to see if is more efficient
  4. N

    My formula with 4 conditions doesn't return correct value

    Hello, I have learnt a lot about excel here, but I'm blocked with a formula which doesn't return the correct value whatever combinations I have tried. In the file below (in french sorry), in the cell (D19) I would like to return the customer name corresponding the expiring contract date (E19)...
  5. N

    Hello .. Introduce yourself

    Hello, I have discovered Chandoo few weeks ago and I have learnt a lot of tricks on excel. I try to reapply them in my job and my life. PS : I'm french and I learn english, so thank you for your understanding.
Back
Top