Thank you everybody for your help,
I think the solution for my problem is sorting the lookup range in
ascending order.
But, by this way I will have to change my table arrangement which I
don't want to.. so I prefered to use another worksheet function/s
like:
Code:
--------------------
=IF(ISNA(MATCH(A4,Feuil1!$E$9:Feuil1!$E$67,0)),"", OFFSET(Feuil1!$C$8,MATCH(A4,Feuil1!$E$9:Feuil1!$E$ 67,0),0))
--------------------
That formula worked perfectly with my case,
Thank you again,
--
LoveCandle
------------------------------------------------------------------------
LoveCandle's Profile:
http://www.excelforum.com/member.php...o&userid=28612
View this thread:
http://www.excelforum.com/showthread...hreadid=566441