Search Values from One sheet into Other and Copy and Paste the Value
Results 1 to 1 of 1

Thread: Search Values from One sheet into Other and Copy and Paste the Value
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2015
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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
    Last edited by Fluff; Jun 26th, 2019 at 07:41 AM. Reason: Updated op

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •