It's because it cannot find a match, you might want to use something like

=IF(ISNA(MATCH(....),"",INDEX(...,MATCH(....)))

which will return a blank if no match is found


--
Regards,

Peo Sjoblom



"ruchie" wrote in message
oups.com...
the problem is with the Match function. I just looked into the
formula's calculations. just dont know why the error is coming though..