+ Reply to Thread
Results 1 to 3 of 3

Pick a number in a column and it shows on another line

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Toulouse
    MS-Off Ver
    Excel 2010
    Posts
    141

    Pick a number in a column and it shows on another line

    Please in fact on A2:A12 there is a drop down menu , with name of fruits let say that in A2 I have option to pick on of those 10 fruit names:
    For exemple
    If I pick Apple on A2 then In C1 I must have Apple displayed
    If I pick Orange on A3 the on D1 shows Orange:
    If I pick Apple again on A4 Then in E1 shows APPLE
    If I pick Bananas in A10 Then In F1 shows Banana
    if I pick Grapes in A11 then in G1 shows Grapes ,
    But if I unselect Grape in A11 then G1 should empty
    an the I pick Melon in A11 and it shows in G1

    Thank you waiting for the help
    If

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Pick a number in a column and it shows on another line

    You will want to provide a link to the original post for this issue:
    http://www.excelforum.com/excel-form...ml#post3527651
    Please click the * icon below if I have helped.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Pick a number in a column and it shows on another line

    Maybe:

    Please Login or Register  to view this content.
    Last edited by JOHN H. DAVIS; 12-31-2013 at 02:46 PM.

+ 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. Whenever Column A shows a value and Column B shows a value....item is counted
    By hatemail13 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-04-2013, 03:18 PM
  2. [SOLVED] how to pick number from selected column
    By Shermaine2010 in forum Excel General
    Replies: 4
    Last Post: 07-25-2012, 10:18 PM
  3. Replies: 17
    Last Post: 03-24-2009, 12:32 PM
  4. Replies: 2
    Last Post: 02-23-2008, 08:28 PM
  5. Line Column on 2 axes that shows stacked colums
    By Paul Henderson in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-27-2005, 11:06 AM

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