+ Reply to Thread
Results 1 to 1 of 1

Show column headings and corresponding values/text based on dropdown selection

  1. #1
    Registered User
    Join Date
    London, England
    MS-Off Ver

    Show column headings and corresponding values/text based on dropdown selection


    I'll start by thanking everyone in advance. So I have a matrix in Excel which essentially shows some category and sub-category areas. When the user clicks on the buttons/dropdowns I want the userform to show the text associated with their selection. i.e. if 'Strategy' is selected then 'Strategy Consultancy' then 'JLP Content' I then want all the different suppliers that fall under those categories to be listed - I've got that bit all working very well (thanks to some help I received on here last year - so thanks!).

    Where I am struggling now is that behind every supplier name there would be a number of other bits of information that I would like to be displayed i.e. company address, telephone number etc so I created a separate sheet ('Supplier Data') with all the other columns I'd be interested in capturing and on the original sheet ("JLP Content") I have data validated dropdowns to select the supplier name from the 'Supplier Data' sheet.

    I want my results userform to show all the columns info from the 'Supplier Data' sheet based on what supplier name has been selected from the data validation dropdown on sheet 'JLP Content'. I've attached the Excel file to make it all make sense. But here is the formula currently being used (which only returns the supplier name from sheet 'JLP Content'):

    Please Login or Register  to view this content.
    Thank you in advanced
    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. Show a Text on a Column based on the values in Two separate columns
    By Harshadewa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-31-2017, 09:59 AM
  2. Show a list of data based from dropdown selection
    By reecerito in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-09-2016, 03:18 AM
  3. [SOLVED] Populate column based on selection from a dropdown
    By dbwaste04 in forum Excel General
    Replies: 5
    Last Post: 11-01-2014, 04:23 PM
  4. Replies: 1
    Last Post: 07-03-2013, 10:50 AM
  5. Change values in cells based on dropdown selection
    By Gert Van Dessel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-19-2013, 09:31 AM
  6. Return Multiple Values Based On Dropdown List Selection
    By tigabalm in forum Excel General
    Replies: 5
    Last Post: 04-01-2010, 07:36 PM
  7. How to change field text based on dropdown selection.
    By Whizbang in forum Word Formatting & General
    Replies: 0
    Last Post: 01-25-2010, 02:48 PM


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