Hi Shane,

The maximum number of matches for one code would be 3.

Lakh rows is equal 100 thousand rows

Appreciate your time.

Looking for positive response.

Thanks in advance



On Mar 15, 12:06*am, Shane Devenshire
wrote:
Hi,

You are going to need to write code for this. *Also, what is the maximun
number of matches that you could find for 1 code? *If it is too many you
won't be able to enter it in a cell. *

and now to really show my ignorance - what is Lakh Row?

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

" wrote:
Hi,

I have two worksheets - Sheet1 and Sheet2

Sheet 1
Col A * * * * * * *Col B
Codes * * * * * * A/C Numbers
Pacific * * * * * * *145762
Atlantic * * * * * * 345782
Monte carlo * * * 478562
Pacific * * * * * * * 785

Sheet 2
Col A
Codes ( unique )
Pacific
Atlantic
Monte Carlo

I am using Excel 2007,
I need to match Sheet 2 Col A data with Sheet1 Col A data,
if any match found i need result in Col B of Sheet 2. If there are
more than one then
the A/C numbers to be separated by comma ( eg., 145762,785)

Sheet 1 has Approximately 1.5 Lakh Row

Sheet 2 has only 10,000 rows.

Please help me guys....