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.
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...
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
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)...
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.