Lookup and Copy Cells with more than 255-characters

[longbow007]

Hello, could someone please help me with the following Excel 2003 VBA problem:

In the attached workbook named: Part Number and Comments Lookup.xls --- there are 2 x worksheets named:

• Master_List
• SupplierComments

I need to look-up the Part Numbers in the Master_List worksheet to see if there is any corresponding Part Numbers in the SupplierComments worksheet.

If so, I need the corresponding Comments in column K (SupplierComments worksheet) to be copied over to the Master_List worksheet in column Q.

For example: Part Number 101 (located in cell C3 of the Master_List worksheet) has a corresponding part number in cell C3 of the SupplierComments worksheet.

The comments in cell K3 (SupplierComments worksheet) need to be copied across to cell Q3 (Master_List worksheet).

The main difficulty is that some of the cells in column K (SupplierComments worksheet) exceed 255 characters.

I was trying a VLOOKUP in cell Q2 (Master_List worksheet) with the following formula and dragging it down column Q, however the cells that contain over 255 characters were truncated:

=VLOOKUP(C2,SupplierComments!$C$2:$K$65,10,False)

If someone could please help me with some VBA code to do this --- it would be greatly appreciated.

Kind regards,

Chris