Hi Experts, I need quick help. I can't share my real data however I have made up this dummy data. My real data has the similar pattern and have more than 10,000 rows. Thanks in advance for your help. Here is the problem. I have 2 sheets. SheetA and SheetB in the same workbook. SheetA Name1 Value1 John Matt Matt Smith Tom Tom John Sara Jack Jill Sara SheetB Name2 Value2 John Matt 23 Smith 33 Jack Sara 41 Tom 94 Jill 62 Result in SheetA Name1 Value1 John 23 Matt 23 Matt 23 Smith 33 Tom 94 Tom 94 John 23 Sara 41 Jack 41 Jill 62 Sara 41 I want to achieve Result in SheetA. 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.

Search Values from One sheet into Other and Copy and Paste the Value

Thread starter stelecoms00
Start date Jun 26, 2019
Tags

john matt sara search and copy info tom

stelecoms00

New Member

Jun 26, 2019

Hi Experts,

I need quick help. I can't share my real data however I have made up this dummy data. My real data has the similar pattern and have more than 10,000 rows. Thanks in advance for your help.

Here is the problem.

I have 2 sheets.

SheetA and SheetB in the same workbook.

SheetA