+ Reply to Thread
Results 1 to 2 of 2

Drop Downs and Conditional formulas

  1. #1
    Registered User
    Join Date
    09-10-2007
    Posts
    1

    Question Drop Downs and Conditional formulas

    I created a drop down menu and I'm wondering how to make it so that when a certain item is selected, a list of information (on another sheet) is pasted in the cells next to the drop down menu automatically.

    Should I try a macro? I'm guessing there's an easier way

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881
    If your drop-down list is using Data Validation or a linkedcell from a combobox, then in the cells to the right of your drop-down you can probably use VLOOKUP formulas to pull in the data from the other workbook/worksheet.

    If your lookup column isn't the first column in your other data source, you can still do it but using INDEX/MATCH formulas.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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