Hello,

I have a spreadsheet with 2 sheets...

1st sheet - contains a list of e-mails received and a column with text and a job number (In 1 cell) e.g.

Harris CK123456
Benjamin TR345756
Craig SGL222888

2nd sheet - contains a column with just the job numbers.

I'd like to match these so If the job number appears on both sheets it returns that job number onto the second sheet.

I hope this makes sense...Gulp!

Thanks in advance.