+ Reply to Thread
Results 1 to 6 of 6

replace values into column from sheet to another after matched

  1. #1
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    280

    replace values into column from sheet to another after matched

    hi experts
    first of all my real data are at least 10000 rows and I attach a simple file with the simple data to understand what I want after match data sheet1 for COLS B,C,E,F with sheet2 for COLS B,C,D ,E if are matched it should replace values in sheet2 for COL E with COL F in sheet1 the result should show in sheet1 in COL F I put the result in sheet expected result
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: replace values into column from sheet to another after matched

    Hi,

    In Sheet1 column F just use in F2 copied down

    =VLOOKUP(A2,SHEET2!$A$2:$E$10000,5,FALSE)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    280

    Re: replace values into column from sheet to another after matched

    it doesn't work for me should match data between two sheets then update the value it should match data sheet1 for COLS B,C,E,F with sheet2 for COLS B,C,D ,E what is existed in COL E in sheet2 should replace in COL P in sheet1 I hope do that by vba to make it fast

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: replace values into column from sheet to another after matched

    Try

    Please Login or Register  to view this content.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: replace values into column from sheet to another after matched

    Quote Originally Posted by Alaa-A View Post
    first of all my real data are at least 10000 rows
    Please Login or Register  to view this content.
    Last edited by jindon; 06-16-2021 at 12:21 AM.

  6. #6
    Forum Contributor
    Join Date
    05-24-2021
    Location
    Palestine
    MS-Off Ver
    2019
    Posts
    280

    Re: replace values into column from sheet to another after matched

    @maniacb, jindon your codes are both work greatly !
    thanks so much for your assistance

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-11-2020, 10:00 PM
  2. [SOLVED] Find and Replace Multiple Columns in Sheet 1 Based on a Column Values in Sheet 2
    By adblog3 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-07-2020, 01:49 PM
  3. transpose values where dates are to be matched from one sheet to another
    By deepakrohella in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2020, 08:57 AM
  4. [SOLVED] Matching text strings to replace with matched values
    By viber52 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-04-2015, 08:04 PM
  5. Counting matched values from another sheet with concatenate always returns zero
    By JerkyTreats in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2013, 06:51 PM
  6. Matched column in a new sheet
    By iamreese in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 11-15-2011, 01:30 AM
  7. Get matched values of a column based on the value of other column
    By Bluecarbon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-23-2009, 09:22 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1