+ Reply to Thread
Results 1 to 3 of 3

Print Text in a cell depending on dropdown selection

  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    england
    MS-Off Ver
    2003
    Posts
    3

    Post Print Text in a cell depending on dropdown selection

    I have included a mock-up document to better explain my problem.
    I'm trying to implement a stock system for my company, but it to have as little human input as possible.




    Thanks,

    Ash Brown
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Print Text in a cell depending on dropdown selection

    Most prefer you explain the problem in the post rather than downloading a workbook and then trying to determine what you actually want. Simple enough in this case but something to remember in the future.

    Use the VLOOKUP function.

    In B6

    =VLOOKUP($A6, $H$4:$L$7, 2)

    Note the Relative/Absolute addresses.

    Copy this across the columns increasing the last parameter as you go across. Finally copy the columns down as far as you want.

    You will also need to handle the #N/A errors for formulas where the cell in Col A is still blank.

  3. #3
    Registered User
    Join Date
    03-02-2017
    Location
    england
    MS-Off Ver
    2003
    Posts
    3

    Re: Print Text in a cell depending on dropdown selection

    This worked a treat thankyou.
    Sorry for not elaborating in my post, i'm new to forums.
    I'll take this all onboard for the future

+ 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. VBA To Copy Cell Contents and Paste Depending on Dropdown Selection
    By josh_paley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-19-2014, 04:42 PM
  2. Cascading values depending on dropdown selection
    By SteveMorrisUK in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 04-27-2013, 06:26 PM
  3. Replies: 3
    Last Post: 01-22-2013, 01:13 AM
  4. Link more than 2 Pivot Charts Dropdown lists
    By reigndelacruz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2012, 05:05 AM
  5. Replies: 1
    Last Post: 01-18-2011, 10:30 AM
  6. enter data automatically in userform depending on dropdown selection
    By ImboJones in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2010, 12:38 AM
  7. Auto entry depending on dropdown selection
    By breal33 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2008, 07:14 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