We help IT Professionals succeed at work.
Get Started

MS Excel VLookup and copy from one worksheet to another

ckwillGWU asked
Last Modified: 2012-05-12
I have a workbook with multiple worksheets. I want to be able to find the text in Worksheet B that matches the text string in a cell in Worksheet A. Once the exact text string is located in Worksheet B that matches Worksheet A, then I want that cell and the cell next to eat (e.g. A1 and A2) from Worksheet B copied over to Worksheet A next to the matching text. Note: There are more rows of data in Worksheet B than in Worsheet A. Also, if text is not found in Worksheet B, then leave the cells in Worksheet A, next to the orignial text string can be left blank. Also, if possible to have the merged data to go to another workheet (Worksheet C) that is combined would work also.

I've attached some dummy data in an excell spreadsheet that I can use if the VB Script, macro's etc are inserted / updated.

Thanks a lot, Chris
Watch Question
This problem has been solved!
Unlock 2 Answers and 17 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE