+ Reply to Thread
Results 1 to 3 of 3

Look up text in a cell and replace with pre-defined text from a database.

  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    SA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Look up text in a cell and replace with pre-defined text from a database.

    Greetings All

    I realy urgently need excel formula help here please...I am sure it can be done.

    1] I extract batches of information which is copied to cell "A1:A1000" by example in "A1":
    "INET IMMEDIATE PMT ABSA BANK KOBA IT SOLUTIONS 1600D807B2"

    2] I have a excell database with various predefined name entries i.e.
    KOBA IT SOLUTIONS
    MUSTEK SA
    NORBAIN SOLUTIONS

    3] I need a formula to look-up or find in the whole description mentioned in cell "A1" or to find something mentioned with "Koba" and copy it to cell "B1" with the pre-defined database description "KOBA IT SOLUTIONS".

    If anybody can help me, it will be grately appreciated and if you could mail me the solution to : ajnortje@vodamail.co.za

    Appreciated and regards
    Anton

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,142

    Re: Look up text in a cell and replace with pre-defined text from a database.

    hi Anton, welcome to the forum. see if the attachment in this link can help you:
    http://www.excelforum.com/excel-form...73#post2920073

    it's something similar i helped someone with. do paste your data inside the file because the Named Range has been set.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    06-26-2012
    Location
    SA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Look up text in a cell and replace with pre-defined text from a database.

    Hi, Benishiryo

    Thank you very much for the quick response...worked on it this morning and it is exactly what I needed.

    Regards
    Anton

+ 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