+ Reply to Thread
Results 1 to 3 of 3

Find in replace with X if value is Y. Y & X is on a list

  1. #1
    Registered User
    Join Date
    09-27-2019
    Location
    Dublin
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    19

    Find in replace with X if value is Y. Y & X is on a list

    Hi,

    I have a weekly data dump with 10s of thousands of transactions that we turn into a report for our client.
    Our software does not have the ability hold all names in completion (only set number of characters available).
    On a monthly basis, this data is used to send a report to a client. We have to replace all incomplete names with the full names for the client (manual ctrl F - Replace etc.)
    There are hundreds of these instances that need to be replaced and it takes a lot of time to complete this task each month.

    Is there a way to automate a find and replace in excel from a given list.
    As well I am happy to utilise a helper column. I had considered this but I do not know of how to utilise something like an 'if' function with so many options on the list.

    Any ideas?

    Kind regards,
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Find in replace with X if value is Y. Y & X is on a list

    Try below formula in D4
    =IFERROR(VLOOKUP(A4,J$4:K$36,2,0),A4)
    use Column D as helper column,
    Copy Data from Column D and paste it in Column A
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Find in replace with X if value is Y. Y & X is on a list

    I assume that your table names will always be the same.

    If So run this Macro.

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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. [SOLVED] Find and Replace Macro to replace list of special characters
    By dcowiesmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2021, 02:01 PM
  2. Replies: 0
    Last Post: 02-13-2021, 03:32 AM
  3. [SOLVED] Find and Replace List from one workbook to another
    By kingsdime29x in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-07-2018, 01:42 PM
  4. [SOLVED] Find and Replace from a List
    By kgb951 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-23-2012, 12:57 PM
  5. macro for find and replace from list
    By jgelbach in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-25-2012, 03:12 PM
  6. Multiple Find and Replace to replace a list of strings
    By WalterP34 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2011, 07:41 PM
  7. Find & Replace from list
    By ChainsawDR in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-27-2010, 09:18 AM

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