Results 1 to 2 of 2

Option buttons with vlookup.

Threaded View

Alan72 Option buttons with vlookup. 09-26-2013, 02:56 PM
arlu1201 Re: Option buttons with... 11-20-2013, 05:20 AM
  1. #1
    Registered User
    Join Date
    09-08-2013
    Location
    Bury St Edmunds, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Option buttons with vlookup.

    I've attached my xlsm file below.

    When you start the excel sheet, the form automatically runs. Fill out the data, including using the three drop downs. Selecting an option button gives you access to three separate lists of engineers in the team combobox.

    I've filled out some examples of the data.

    When you click next, vlookups populate the sheet with the telephone numbers of the SAP and the PM but I can't work out how to lookup the team phone number when each of the option buttons are selected. The different option buttons select different named ranges.

    I could probably get round it by using a named array that would cover all of the engineers but as new members join the company, this list changes and therefore the array would change so I'd like to try and avoid that if possible.


    I have a couple more questions but I'll post more relevant threads for those.

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. enable certain combo buttons based on user selected option buttons
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-20-2013, 06:43 AM
  2. How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?
    By mickwooduclan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 10:01 AM
  3. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM
  4. Replies: 3
    Last Post: 03-27-2012, 07:06 PM
  5. Using control toolbox's option buttons to switch between vlookup tables
    By da_sprite in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-15-2009, 05:45 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