Help needed to find the right formula?

[SDCSpeedy]

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.

[oeldere]

Please change the title of your questions.

Otherwise we are not allowed to help you.

After done that.

You get better help if you post an Excel-example of your workbook, without confidential information.
Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.
Use BEFORE/AFTER sheets if that helps make it clearer.

[Ace_XL]

Use on 2nd sheet

=if(iserror(vlookup("*"&A1&"*",Sheet1!A:A,1,false)),"",vlookup("*"&A1&"*",Sheet1!A:A,1,false))
or
=if(iserror(vlookup("*"&A1&"*",Sheet1!A:A,1,false)),"",A1)

depending on what you want returned.

[arlu1201]

SDCSpeedy,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.