+ Reply to Thread
Results 1 to 3 of 3

Search and Replace

  1. #1
    Registered User
    Join Date
    02-09-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    2

    Search and Replace

    My boss asked for this, and I have no idea how to do it. He wants to be able to type into a cell a number of a product that we make, and have it replaced with the description. We have about 300 products and he gave me a list with the product numbers and descriptions. Is there any way to do this? I don't think he would mind if the description appeared on a different cell.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,041

    Re: Search and Replace

    Use VLOOKUP
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    02-09-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Search and Replace

    I don't know how to use the vlookup. if they type in the number where in the bottom values does it go? where does the list where they're being looked up go? Where does the info that they need to bring back go? and where does the location of the info retured go in the bottom values?

    Lookup_value
    Table_array
    Col_index_num
    Range_lookup

    type in
    8

    get back
    Product 8

    Number list
    1
    2
    3
    4
    5
    6
    7
    8


    Produt List
    Product1
    Product2
    Product3
    Product4
    Product5
    Product6
    Product7
    Product8
    Last edited by hsalazar; 02-09-2012 at 10:29 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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