+ Reply to Thread
Results 1 to 2 of 2

Need to replace values in only certain rows of a column based on separate column values

  1. #1
    Registered User
    Join Date
    12-08-2021
    Location
    United States
    MS-Off Ver
    365
    Posts
    1

    Need to replace values in only certain rows of a column based on separate column values

    I did about 40 find and replaces (FRs) but did not change the output on one of them. 6 hours later i discovered my mistake. My data is on names and their job roles, my FRs narrowed the job roles down into President, Vice President, Director, and Other. Unfortunately, I accidentally turned Vice President into Other. Now actual "Others" are mixed with the vice presidents who are now labelled as others.

    I still have the raw data with the names and roles, if I get all the Vice Presidents labelled correctly on the raw sheet, is there anyway for me to only replace only roles on a separate sheet based on the names that are in the same row as the Vice President label?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    940

    Re: Need to replace values in only certain rows of a column based on separate column value

    Welcome to the forum.

    If I get it right, try this in E2 and copy down:
    =INDEX($B$2:$B$8,MATCH(D2,$A$2:$A$8,0))

    Good luck!

+ 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. Multiple column values into separate rows
    By victoryyc in forum Excel General
    Replies: 2
    Last Post: 09-05-2020, 12:54 AM
  2. Assign values to categories of values based on separate column attribute.
    By jenbot83 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2017, 02:17 PM
  3. [SOLVED] Replace Column B Values based on Column A
    By karlosdejackal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2015, 09:22 AM
  4. [SOLVED] Replace values in rows based on criteria in column B
    By Marq555 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-03-2015, 10:25 AM
  5. Sum up a column based off adjacent column and replace values with the sum.
    By kleptilian in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-13-2015, 11:55 AM
  6. Replies: 8
    Last Post: 11-25-2014, 05:11 PM
  7. [SOLVED] Adding Values Based on a Separate Column
    By binder in forum Excel General
    Replies: 2
    Last Post: 02-14-2005, 04:06 PM

Tags for this Thread

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