+ Reply to Thread
Results 1 to 2 of 2

Replacing text with corresponding text according to table

  1. #1
    Registered User
    Join Date
    02-11-2010
    Location
    Finland
    MS-Off Ver
    Excel 2007
    Posts
    6

    Replacing text with corresponding text according to table

    Hello Excel Forum,

    I'm trying to replace a column consisting of codes (such as A1.1 or C1.6) with text that corresponds to each of those codes (so say A1.1 = John and C1.6 = Mary). Most codes appear more than once and in no particular order.

    I've got another table that documents how those codes correspond with all the codes in column A and corresponding text in column B.

    How can I automatically the column of codes with the corresponding texts according to the correspondencies defined in my second table?

    Thanks so much for your help!

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Replacing text with corresponding text according to table

    Hi gaggia,

    This sounds like you need a Lookup Table where the "A1.1" is in column A and the "John" is in column B in the same row.

    Then create a new column in your original table and use a =VLookup(A1,..Your lookup table.., 2, 0) which will return John when A1 is "A1.1"

    After you get all those lookups correct, copy the whole column and paste over the original column using "Values Only" and that should be your answer.

    https://www.thoughtco.com/use-excels...nction-3123743
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Replacing specific text in a cell by row and replace with text in another row
    By merQrey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2014, 10:05 AM
  2. [SOLVED] Macro finding text and replacing text
    By allenz0rz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2013, 07:48 PM
  3. IF function: Using text in logical_test with multiple variables and replacing with text
    By SarahRachelJones in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2012, 02:17 PM
  4. Replacing text according to a table?
    By dadel in forum Excel General
    Replies: 14
    Last Post: 07-06-2009, 09:09 AM
  5. Recognizing text and replacing with other text
    By Funk in forum Excel General
    Replies: 3
    Last Post: 11-24-2007, 07:59 AM
  6. [SOLVED] replacing text in all cells with existing text plus something
    By avi2001 in forum Excel General
    Replies: 2
    Last Post: 11-02-2005, 06:20 PM
  7. Replies: 2
    Last Post: 11-02-2005, 06:17 PM
  8. [SOLVED] Replacing #N/A with other text
    By Dave in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 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