+ Reply to Thread
Results 1 to 5 of 5

Select item from dropdown menu, Populate different specific cell with specific item info.

  1. #1
    Registered User
    Join Date
    12-30-2018
    Location
    Toronto, Canada
    MS-Off Ver
    Google Sheets
    Posts
    3

    Select item from dropdown menu, Populate different specific cell with specific item info.

    Please attached image. I am looking for the formula to use in Column "C" to get data from line item based on a dropdown menu input. I am using Google Sheets for this.

    - Dave





    Mystique Excel Formula.jpg
    Attached Files Attached Files
    Last edited by barstone; 12-31-2018 at 11:24 AM. Reason: Adding Excel Attachment

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,939

    Re: Select item from dropdown menu, Populate different specific cell with specific item in

    Hi and welcome to the forum Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Picture are rarely much use an no one wants to recreae your data in order to test a solution.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-30-2018
    Location
    Toronto, Canada
    MS-Off Ver
    Google Sheets
    Posts
    3

    Re: Select item from dropdown menu, Populate different specific cell with specific item in

    Thank you. Of course, sorry about that completely new to this forum. I have attached an Excel document. Please see above.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,939

    Re: Select item from dropdown menu, Populate different specific cell with specific item in

    Hi Dave

    Are you able to zip up the google sheets doc as well and upload, or point me to the file on a shared site?

  5. #5
    Registered User
    Join Date
    12-30-2018
    Location
    Toronto, Canada
    MS-Off Ver
    Google Sheets
    Posts
    3

    Re: Select item from dropdown menu, Populate different specific cell with specific item in

    here you go. Let me know if it works or not.
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 12-14-2016, 12:20 AM
  2. [SOLVED] Select Specific Item in ListBox
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 08-15-2014, 07:15 AM
  3. [SOLVED] Macro to populate a specific cell with each item on a list and save
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-27-2013, 10:02 PM
  4. Replies: 2
    Last Post: 08-02-2013, 08:04 AM
  5. Select specific Pivot-table item
    By bobo1000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2012, 03:06 AM
  6. Replies: 9
    Last Post: 05-22-2011, 09:26 AM
  7. When I select from drop down menu I would like the next column to populate a specific cost.
    By missmarley@gmail.com in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2006, 07:25 PM

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