Matching from a Range

Originally Posted by chandan12

Thanks. I shall try it. Please note, the numbers of entry in BB sheet will increases day by day and it may go upto row 65000.

Hi chandan12
If the numbers of entry in BB sheet will increases day by day and it may go upto row 65000 you shouldn't use Fomula. I think VBA method is better method for this case. See my file, press Run button to view result.