+ Reply to Thread
Results 1 to 2 of 2

How do i change the text in a specific cell based off of criteria in another

  1. #1
    Registered User
    Join Date
    07-19-2016
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    4

    How do i change the text in a specific cell based off of criteria in another

    I'm trying to write a formula that will change the wording in a cell based off of criteria in another.

    So for instance if A1 contains " Abbotts Repair" I need it to change to " Abbotts Car Repair". I know I can do an IF formula and that works to a point, however I have many different variations of "Abbotts Repair". I didn't want to do nested IF's as there will be loads and it will take me ages to individually do each IF.

    I have lots of different cells that I need to change, so I'm looking for a quick way to do this.

    Any help would be greatly appreciated.

    Thanks

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: How do i change the text in a specific cell based off of criteria in another

    One way to do this is to make a conversion table with all the various incantations of "Abbotts Repair" in the first column and then all of them "map" to "Abbots Car Repair" in the second column. Then do a VLOOKUP against this table to get the value.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Macro to Change Font Size Based on if Cell Contains Specific Text
    By karpfy19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2016, 08:12 PM
  2. Replies: 5
    Last Post: 09-23-2015, 04:26 AM
  3. [SOLVED] Look up based on specific text criteria.
    By tokyojo1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2014, 03:08 PM
  4. [SOLVED] Change Color of cell based on specific letter / text
    By steven_e in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2013, 04:46 PM
  5. [SOLVED] Dynamic repeating order that needs to change based on specific criteria
    By rcoope02 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-14-2013, 11:30 AM
  6. Change text in cell based on criteria within that same cell.
    By ds84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2008, 04:19 PM
  7. Change text based on other cell criteria?
    By ansoriano1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2006, 07:05 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