I have a spreadsheet with 2 worksheets. 1 worksheet1 has 1 column of names "Smith, Bob" 1 worksheet2 has multiple columns of data, including the name. I'm trying to find a formula that will find the names from worksheet2 in worksheet1 and when a match is found, it returns all columns of data from worksheet1 into a new worksheet3. Many thanks!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel 2007: If Match Found, Return Worksheet

Thread starter nbwoodruff
Start date Oct 24, 2013
Tags

excel excel-2007

nbwoodruff

New Member

Oct 24, 2013

<TBODY sizset="0" sizcache06131772706928872="1943">
[TD="class: votecell"]

[/TD]
[TD="class: postcell"]I have a spreadsheet with 2 worksheets.

<CODE> 1 worksheet1 has 1 column of names "Smith, Bob" 1 worksheet2 has multiple columns of data, including the name.</CODE></PRE>I'm trying to find a formula that will find the names from worksheet2 in worksheet1 and when a match is found, it returns all columns of data from worksheet1 into a new worksheet3.

Many thanks!

[/TD]

</TBODY>