+ Reply to Thread
Results 1 to 7 of 7

Find and Replace - Replacing Values on One Sheet with Values from Another

  1. #1
    Registered User
    Join Date
    11-18-2019
    Location
    Philly, PA
    MS-Off Ver
    2010
    Posts
    3

    Find and Replace - Replacing Values on One Sheet with Values from Another

    Hi,

    I have 2 sheets with data, the one has two columns where the data in one column (column 1) is married to the other column (column 2) (cell by cell). On the other sheet 2, I have a huge data set and one of the columns has the same data as column 1 from the Sheet 1 (just a lot more rows of it). I want to find the best function or formula to replace that data in sheet 2 (same data as column 1 on sheet 1) with the data from sheet 1, column 2. in essence if on sheet 1, column 1, I have banana and that is to be replaced with orange (which is in sheet 1, column 2 just for that row), now I want to replace the banana on sheet 2 with the orange on sheet 1, column 2. I would like to set the function to use the whole table from sheet 1 rather than to go one by one with the find and replace function.

    Thanks in advance!

    Yoyo
    Attached Files Attached Files
    Last edited by yoanakunova; 11-18-2019 at 10:47 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,372

    Re: Best Formula/Function to use?

    Welcome to the forum.

    Did you see the yellow banner at the top of the page?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,794

    Re: Best Formula/Function to use?

    Your thread title is no good. What would you have used if you were searching GOOGLE for an answer? I can't follow your request, so cant help suggesting an alternative. Also:

    Please read the yellow banner and attach a SMALL sample sheet, with good data and a few manually calculated answers.
    Glenn



  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,372

    Re: Replacing Values on One Sheet with Values from Another

    I have attempted to update the thread title, but it needs more work.

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

  5. #5
    Registered User
    Join Date
    11-18-2019
    Location
    Philly, PA
    MS-Off Ver
    2010
    Posts
    3

    Re: Find and Replace - Replacing Values on One Sheet with Values from Another

    Hi,

    Please disregard my post, I found help in another forum, since I needed a solution ASAP.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2211
    Posts
    36,794

    Re: Find and Replace - Replacing Values on One Sheet with Values from Another

    Glad you got it sorted.

    But.

    You said that you have posted the same question elsewhere.... but didn't tell us. Feel free to cross-post on other sites... Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

    Do not keep it a secret. We all are willing to give you our time, freely. However, some of us (especially me!!) get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

    1) if you have cross-posted, and

    2) the URL of the cross post(s).

    That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

  7. #7
    Registered User
    Join Date
    11-18-2019
    Location
    Philly, PA
    MS-Off Ver
    2010
    Posts
    3

    Re: Find and Replace - Replacing Values on One Sheet with Values from Another

    Thanks for all the heads up, all I wanted to find out is suggestions on the function type I should use, but what I got was that my posts wasn't good, the thread name wasn't good either. I changed it as well as followed direction to include example. Nobody looked at it, so I went somewhere else for help. I am sorry if you think I wasted your time, but I also wasted my time making my post fit your standards for which I didn't even get one response with any kind of suggestion. Maybe instead of bombarding me with how and what the thread should look like you could have found details of what the actual problem was and give suggestions for solving it. I guess this forum is not for me so please feel free to delete my account.

+ 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. Formula Structure Error When Combining IF Function with VLOOKUP Function
    By EverClever in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-16-2017, 03:11 PM
  2. Replies: 7
    Last Post: 10-18-2016, 02:13 PM
  3. Replies: 3
    Last Post: 09-26-2016, 02:42 PM
  4. Multiple Vlookup Normal Formula (not array formula) or VBA Function Required
    By BoopathiK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2015, 03:06 AM
  5. Formula Creation: Using List Function + Subtraction Function
    By HelpMe! in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2013, 04:52 PM
  6. Replies: 0
    Last Post: 01-19-2013, 01:35 PM
  7. Need Excel formula in Macro using Subtotal formula with If function
    By mbnewton1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2013, 03:00 PM

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