Nav,
Glad it's done the trick and thank you for the feedback.

"Nav" wrote:


Dear Topper,

I think I get it now. Thankx for your help.

I have attached the jpeg file on the formula.

instead of +1, I replaced it with -2. Then, the result was perfect.

Without your help, this will never happen to me.

Thx a lot,


+-------------------------------------------------------------------+
|Filename: multiple match output 2.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4948 |
+-------------------------------------------------------------------+

--
Nav
------------------------------------------------------------------------
Nav's Profile: http://www.excelforum.com/member.php...o&userid=35831
View this thread: http://www.excelforum.com/showthread...hreadid=556118