Hello

I have 2 spreadsheets.

Spreadsheet 1, Column "D" lists my unique job numbers. If the job number is found in Spreadsheet 2, column "G", then i need to copy the contents of Column "L" from Spreadsheet 1 over to the corresponding/matched Job number in Sheet 2 and paste the contents from Column "L" Sheet1, into Column "CI" in SHeet 2.

I'm lost....please help!!

thanks