Thanks Mark,

I just restricted the range from whole column to specific column range and the function is working like a charm...

FROM
=VlookupAll(A2,Sheet2!A:B,2)

To something like,

=VlookupAll(A2,Sheet2!$A$1:$B$300,2)


Thanks for the advice..