+ Reply to Thread
Results 1 to 4 of 4

Cells selecting a word input depending on input of another cell

  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Cells selecting a word input depending on input of another cell

    Hi

    I have been asked to create a spreadsheet and one part of the spreadsheet sees me input the commercial name of a product (lets call them Product A, B C and D). Each of these products have an active ingredient in them - Ingredient A, B, C and D. These active ingredients need to be inputted into the adjacent column each time i enter the products name.

    What i need to know is how can i get it so when an entry is made in one column listing the product sold (ie Product B) the next column automatically inputs the respective active ingredient (Ingredient B).

    I have tried IF formulas but i think I am looking down the wrong path.

    Any assistance would be massively appreciated.

    Chris

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Cells selecting a word input depending on input of another cell

    Hello. Welcome to the forum.

    One way is to create a table with products and their active ingredient and then use INDEX & MATCH or VLOOKUP functions to get your result.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    09-14-2012
    Location
    england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Cells selecting a word input depending on input of another cell

    Thanks very much. That seems to do the trick perfectly.

    Being asked to redo a lot of spreadsheets at work at the moment so this probably won't be my last request for help.

    Chris

    ps thanks for such a quick response

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Cells selecting a word input depending on input of another cell

    In any case, if you will need some more help on this, upload a small sample workbook..

+ 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