+ Reply to Thread
Results 1 to 3 of 3

find and replace for instance

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    Franksville, WI
    MS-Off Ver
    Excel 2010
    Posts
    4

    find and replace for instance

    Hello world.
    I have to find and replace across multiple instances. I have the following on two sheets in one workbook.

    Sheet 1
    A
    a1 = x
    a2 = y
    a3 = z
    a4 = y
    a5 = z

    Sheet 2
    A...........B
    a1 = a | b1 = x
    a2 = b | b2 = y
    a3 = c | b3 = z

    What I need to accomplish is for any time the value of B1 in sheet two is found in column A on sheet 1, that cell in column A is changed to the value in A1 on sheet 2.

    So the end result of the above would be:

    Sheet 1
    a1 = a
    a2 = b
    a3 = c
    a4 = b
    a5 = c

    If it makes things easier I can also easily put the values in Sheet 2 into sheet 1 in two empty columns.

    Thanks,

    NickTater

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: find and replace for instance

    NickTater,

    Something like this should work for you:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    12-04-2012
    Location
    Franksville, WI
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: find and replace for instance

    Thanks, Worked great.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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